Shilpa Kondekar

903-***-****

ad47aq@r.postjobfree.com

ETL Developer/Business Analyst

Professional summary:

8+ years IT experience in Business Analysis, Data Warehousing ETL- Development, Migration.

Proficient in ETL processes with Informatica, handling various data sources (Oracle, SQL Server, PostgreSQL, AWS S3, Snowflake Data Lake, Flat files, JSON, XML).

Skilled in database management (Oracle, SQL Server, PostgreSQL, Teradata), performance tuning, and maintenance.

Proficient in full Data warehouse development lifecycle, including requirements gathering, coding, testing, and documentation.

Expertise in Data modeling concepts, Agile Methodology, and relational database design.

Hands-on experience with stored procedures, triggers, views, Materialized views, and constraints.

Proficient in business requirements elicitation, Gap analysis, SWOT analysis and functional specifications development.

Familiarity with JIRA, ServiceNow for ticketing and tracking.

Experienced with Informatica Intelligent Cloud Services (IICS) and Unix shell scripting.

Knowledgeable in Snowflake Data Warehouse and related components like snow pipes, stored procedures, and file formats.

Educational Details:

Bachelor’s in science in 1994 from Mumbai University.

Diploma in Computer Application in 1997 Maharashtra State Board.

Professional Experience:

Dallas County Election Center, Dallas TX Jan 2024 –Till Date

Role: Consultant

Responsibilities:

Receive, sort, and prepare ballots for counting. Ensure that all ballots are properly handled and accounted for according to established procedures.

Operate electronic scanning and counting machines to accurately tabulate votes. Monitor machines for any malfunctions or errors and report issues to supervisory staff promptly.

Conduct quality checks on processed ballots to verify accuracy and completeness. Identify and resolve discrepancies or irregularities in accordance with election guidelines.

Record vote totals and other relevant information into electronic systems accurately and efficiently. Maintain detailed records of all ballots processed and ensure data integrity throughout the counting process.

Adhere to all legal requirements, regulations, and policies governing the election process. Follow established protocols for ballot security, confidentiality, and chain of custody procedures.

Collaborate effectively with fellow workers, supervisors, and election officials to maintain a smooth and efficient workflow. Communicate any issues or concerns promptly to ensure timely resolution.

Participate in training sessions to learn and understand election procedures, equipment operation, and relevant legal requirements. Stay informed about updates or changes to election laws and regulations.

Provide support as needed in other areas of election operations, such as voter assistance, registration, or absentee ballot processing, during peak periods or as directed by supervisory staff.

Allianz Life Insurance, Minneapolis, MN Oct 2022 – April 2023

Role: Sr. Consultant

Description: Allianz Life Insurance Company of North America provides annuities and Life Insurance products in the United States. This is Batch Optimization Project where we need to do performance analysis for slow running jobs and provide recommendations. The performance improvement approach is at infrastructure level, Database level, Informatica level and process level.

Responsibilities:

Utilized Agile project management tools (e.g., Polarian, Slack, Google Sheets) to track sprint progress and manage backlog items, ensuring collaboration and transparency within the team.

Conducted performance analysis to identify inefficiencies in data extraction, transformation, and loading processes, implementing advanced Informatica features and best practices to optimize workflows.

Engineered optimized data integration workflows, resulting in substantial reductions in processing times and improved system performance.

Review and optimize T-SQL queries by eliminating redundant joins, reducing the number of rows returned, and optimizing predicate filters.

Reviewed and optimized T-SQL queries, coordinated with DBAs for database configuration enhancements like increasing cost threshold for parallelism, TEMPDB files and adjusted SQL Server settings for improved performance.

Implemented pushdown optimizations and partitioning strategies at the source and target levels to enhance Informatica workflow performance.

Conducted unit testing and data validation, deploying code to QA environments after successful testing in DEV.

Provided on-the-job training for IICS platform, developing new mappings and task flows to migrate data from on-prem systems to AWS S3 buckets.

Utilized IICS to fetch data from AWS S3 buckets, building data pipelines to load data into Snowflake tables while applying business logic.

Environment: MS SQL server/CA Automation /Informatica Power Center 10.5/IICS/AWS S3/Snowflake

Bread Financial, Columbus, Ohio Oct 2021-June 2022

Role: Data Engineer

Description: Implementing Noble Harmony suite to centralize and manage all outbound contact efforts (SMS, Email, IVR, Predictive view first, one touch, compliance dialing campaigns) for Bread Financial. This consolidation enhances compliance management and strategic outreach capabilities, streamlining reporting and management processes. Transitioning from Avaya Predictive Dialing to inject customer data into the EDW.

Responsibilities:

Managed various stages of the SDLC including planning, requirements gathering, design, testing, deployment, and maintenance.

Implemented Agile practices for end-to-end project deliverables, ensuring efficiency and adaptability.

Facilitated effective communication and collaboration between business stakeholders and technical teams throughout the project lifecycle.

Developed Informatica mappings for 28 Phase I tables and 23 Phase 2 tables, facilitating incremental data loading.

Managed the extraction of data from the Avaya Predictive Dialing platform into the Enterprise Data Warehouse (EDW)Postgre SQL

to Yellowbrick Database incrementally ensuring data integrity and accuracy.

Led testing to validate the functionality and performance of the integrated solution, ensuring a smooth transition and minimal disruption to operations.

Successfully carried out the deployment of workflows for Phase I and Phase II and generated XMLs for loading data into the Stage environment.

Conducted unit testing, error resolution, and data validation to meet project requirements.

Implemented Unix shell scripting for workflow triggering, deployment, and file handling.

Managed migration of ETL components, shell scripts, and DDL scripts, providing support for initial loads and production maintenance.

Validated data migration from legacy database Netezza to Yellow brick, identifying and resolving duplicate data issues.

Developed a performance metrics dashboard to monitor the efficacy of the Noble Harmony suite project for Phase I and II.

Environment: Informatica Power Center 10.2, PL/SQL, PostgreSQL, TWS, UNIX, JIRA

Precision Document Solutions Sept 2019 - Aug 2021

Role: ETL developer

Description: PDS provides various services like patient access, financial operations and purchasing, Health Information management to all healthcare clients nationwide. This project is to build a central Database for Health Information Management which is compatible to Hospital Information System HIS and Electronic Medical Record EMR.

Responsibilities:

•Conducted Business Analysis and Requirements Collection.

•Prepared design documents and collaborated with data modelers to design Dimension and fact tables to achieve ETL logic.

•Utilized Informatica PowerCenter 9.5 to build Source-to-Target mappings for Data warehouse loading.

•Created mapping documents outlining data flow and extracted data from various sources into staging areas.

•Developed mapping parameters, variables, and mapplets for mapping flexibility.

•Implemented Type 1 and Type 2 Slowly Changing Dimension mappings.

•Utilized UNIX shell scripts and PMCMD commands for FTP and repository backup.

•Conducted performance tuning at source, target, mapping, session, and system levels.

•Prepared deployment groups for moving mappings across development to QA environment.

•Successfully developed and implemented a centralized Database for Health Information Management, seamlessly compatible with Hospital Information Systems (HIS) and Electronic Medical Records (EMR), enhancing operational efficiency and data accessibility for healthcare clients nationwide.

Environment: Informatica Power Center 10.2, PL/SQL, Oracle 10g/9i, Autosys, UNIX, ServiceNow

CVS Health -Richardson-TX Jan 2015 - Jun 2019

Role: Business Analyst

Description: CVS Health aimed to revolutionize health and wellness through consumer engagement products. The SI-DW project's goal was to construct a data warehouse facilitating product delivery and enhancing engagement. Patient, consumer, and product data (HL7 V2, PII, PHI) were extracted, transformed, and loaded into the target database via an ETL tool. Utilizing Informatica PowerCenter Designer, we analyzed source data from Oracle 10g, DB2, SQL Server, and flat files. Business rules were incorporated using the tool's functionalities to ensure efficient extraction and transformation.

Responsibilities:

•Led SI-DW project implementation, driving CVS Health's mission in health and wellness consumer engagement.

•Built a robust data warehouse to deliver products and enhance consumer engagement.

•Designed ETL methodology based on business requirements and functional specifications.

•Followed Agile practices for project delivery, creating use cases and diagrams using UML.

•Analyzed CVS Health's segments to propose streamlined workflows and solutions.

•Utilized SQL to extract insights and trends from CVS Health's data.

•Ensured technology solutions aligned with healthcare regulations like HIPAA.

•Monitored solution performance and gathered user feedback for continuous improvement.

•Leveraged Informatica PowerCenter Designer for data extraction and transformation.

•Collaborated closely with cross-functional teams to ensure seamless data flow and alignment with project timelines

•Drove innovation and received recognition for project management skills.

•Provided strategic insights and technical expertise throughout the project lifecycle.

Environment: SQL Server 2005, DB2, Autosys, Informatica Power Center 9.5, UNIX

Cipla Ltd – India Feb 2004- June 2013

Role: Sr. Purchase Manager

Description: Spearheading and overseeing the efforts in purchasing supplies for a company. I oversaw managing the purchasing team, gathering purchase requests, identifying the company's needs, and setting goals in adherence to the budget.

Responsibilities:

Streamlined procurement processes for various packaging materials required for export markets.

Facilitated efficient planning and material forecasting through regular weekly and monthly meetings.

Ensured timely delivery of materials to manufacturing units, optimizing production schedules.

Monitored material deliveries using Excel-generated daily reports, ensuring accuracy and timeliness.

Successfully developed local vendors, reducing procurement costs, and enhancing supply chain efficiency.

Implemented vendor development programs, providing training to vendors for improved performance.

Implemented inventory management systems to prevent overstocking and minimize wastage.

Utilized SQL/Oracle Database to develop reports on order trends and forecast packing material requirements and decision-making.

Contact this candidate