Swati Madhu

• Determined project needs and identified system specifications.
• Analysed the existing systems and created below list of documents as part of deliverables to recommend the client with a one stop Data warehouse solution for their investment management reporting requirement.
  1. Assessment reports and Mapping documents for Individual systems.
  2. Summarized system analysis to cover use cases, reporting frameworks, data sources details, security, data frequency and high-level business logic detailing, Overall Business Process Flow, Proposed Solution Architecture
  3. POC using Snowflake + Tableau
  4. Technology Evaluation
  5. Development Phase task break down and epics identification
  6. Development Phase Estimation
  7. SWOT Analysis to include out of the box features for current systems
• Planned and designed the structure of technology systems, discussed these with the client.Recommended best products and systems to client
• Communicated system requirements to software designers and developers; Explained system structure to them and aided throughout the discovery phase.
• Ensured that team follows best practices and standards during analysis of existing systems
• Worked with senior IT personnel to devise plans for future IT requirements of the project
• Analysed existing systems/processes for client (CAREFIRST, Health Insurance company) and created detailed functional and technical specification documents for lift and shift of CareFirst Budget Process
• Performed Data/Gap Analysis, and created Data Analysis Mapping Document documentation
• Created AS-IS process flow diagram & conceptual model for the existing workflow mappings in Informatica Power Center.
• Converted source queries from SQL Server to Snowflake DB
• Created end to end Informatica Cloud Mappings, Mapping tasks and task-flow and migrated the build from Dev environment to PREPROD and PROD.Successfully loaded data in Production.
• Responsible to build data models and deploying the dashboards into Power BI.com service. Performed performance tuning on SQL queries and stored procedures.

• Gathered requirements, created detailed functional and technical design documents, defined scopes, allocated resources and established schedules meeting for exceeding project demands.
• Translated business rules and functionality requirements into ETL/ELT procedures using SSIS
  
• Enforced alignment of project strategy with business objectives and made modifications to promote efficient project completion.
• Managed assignments/ workload for team of 7+developers to meet project milestone and delivery goals, and motivated project teams to promote collaboration and keep members on-task and productive.
• Identified innovative and automated approaches to routine tasks, making suggestions that were widely received using Power Platform.
• Explained technical information in clear terms to non-technical individuals to promote better understanding.
• Owned multiple end - to-end transformations of customer business analytics reporting challenges decomposing them into a combination of suitable infrastructure.
• Developed and implemented performance improvement strategies and plans to promote continuous improvement.
  
• Designing database by adding tables, relationships ,stored procedures ,views, Extensive SQL querying on Database , Data warehouse using Azure services like SQL, Data Factory, Data Lake Storage and Logic Apps, etc
• Produced Power BI reports and dashboards from multiple data sources using data blending.
  

• Manage and setup metadata configuration changes for file transfer applications used by Deutsche Bank employees in Oracle database using PLSQL & Unix shell scripting
  
• Manage and analyze Ticketing and Data inventory applications used by Goldman Sachs employees and also created weekly/monthly reports of most frequently occurring issues
  
• Improved application performance by determining root cause of issues and provided permanent resolution.
  
• Supported multiple concurrent projects enabling delivery efficiencies and technical resolution.
  
• Performed logical design, maintenance, monitoring, tuning and optimization for DB2 database
  
• Implemented complex business logic and created rigorous reporting tool for MAPFRE insurance claim & policy reports using PLSQL and Crystal Reports

• Develop complex reports to calculate expedited orders information in logistics application using PLSQL
  
• Created database Objects like Tables, Views, Constraints, Indexes, Triggers, PLSQL Table and Functions/Stored Procedures to ensure efficient data insertion and retrieval as per user requirements
• Devised high-quality database solutions ranging in size and complexity, increasing productivity and improving data sharing.
• Drove data analysis, resolving complex business issues and proposing long-term system solutions.
  
• Collaborate with client to create scheduled and ad-hoc reports
  

• Designed and implemented TSQL queries for reporting and complex solution development.
• Developed custom database objects, stored procedures and delivered application support.
• Produced high-standard database solutions to meet stability, reliability and performance metrics.
• Analyzed existing SQL queries to identify opportunities for improvements
• Querying SQL SERVER database to generate weekly and monthly reports
• Created SSIS packages to migrate flat file data into SQL SERVER 2008

BSC-IT

HSC

SSC