Swati Sinha

TDM/SQL Developer

+1-513-***-****

adln3v@r.postjobfree.com

SUMMARY

Cincinnati, ohio,45040

• 6+ years of IT experience in all phase of Software Development Life Cycle (SDLC) involving System Requirements, Analysis, Design, Development, Implementation, Integration, Testing, Deployment and Maintenance.

• Proficient as SQL developer and involved in database design, development and administration with Microsoft SQL Server 2014/2012/2008/2005 using SQL Server Integration Service (SSIS), SQL Server Analysis Service (SSAS), SQL Server Reporting Service (SSRS).

• Core SME and possess specialized knowledge in Broadcom (formerly CA Technologies) TDM Product with Delivery/Support, Implementation and Business Development experience

• Good hands-on experience on Informatica ILM TDM, and Delphix

• Part of Delivery Excellence SOW reviewers for TDM from Center of Excellence team

• Expertise in Requirement Analysis, Test Planning, Test Case Design, Test Tool Usage, Test Execution, Defect Management, Risk Analysis, Metrics and Building Test Environment

• Expertise in writing macros for metrics collections and QA standards.

• Good Experience in Software Development Life Cycle (SDLC/STLC).

• Extensive experience in all phase of STLC in both Waterfall and Agile.

• Hands on experience in System, Integration, Regression, Mobile, GUI and UAT Testing. Strived on process enhancements wherever required.

• Capable of working as a team lead with leadership, communication and interpersonal qualities.

• Good working experience with conducting trainings and actively participating in roadshows and Client visits, demo and awareness for Test Data Management components

• Good skills, Self-motivated, proactive and capable of taking up assignments independently with a quest and zeal to learn new technologies and undertake challenging tasks.

• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models, data integrity, SQL joins and query writing.

• Extensive knowledge and experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.

• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.

• Experienced in relational database design, SQL queries, Stored procedures, Functions, clustered, non-clustered indexes and indexed, views, Performance tuning.

• Very much comfortable in analyzing, debugging, troubleshooting and solving problems in application.

• Highly motivated and a self-starter with effective communication and organizational skills, combined with attention to detail and business process improvements.

• Committed to excellence, highly self-motivated, self-motivator, fast-learner, team player, ability to deal with people diplomatically and a prudent developer with analytical and strong problem-solving skills with excellent communication.

TECHNICAL SKILLS:

Languages

Transact SQL, PL/SQL, XML, C, Visual Basic 6.0, HTML.LUA

Databases

SQL Server 2016/2014/2012/2008/2008R2/2005/2000R2, MS Access, Oracle 9i, Oracle 10g, 11g, MySQL, DB2

Analysis/Reporting Tools

SQL Server Reporting Service (SSRS), SQL Server Analysis

ETL Tools

SSIS, Business Intelligence Development Studio (BIDS)

TDM Tools

CA TDM, IBM Optim

Database Tools

SQL Query Analyzer, SQL).

Operating Systems

Windows NT/2000/XP Pro/Vista, Windows Server 2000/2003/2008, Linux, Unix

Version Control/Utilities

CVS, SVN and GIT Hub 2.12.0, JIRA, Citrix

EDUCATION:

Rajasthan Technical University, KOTA 2006-2010

Bachelor’s Degree in Electronics and Communications

r

PROFESSIONAL EXPERIENCE:

Client: Truist

Employer : Infosys

Duration: Aug2020- Present

Role: TDM Lead

Responsibility:

• Strategic Role working closely with Dev, QA and Business

• Working With TDM team

• Evaluating and selecting feasible solutions and implementing any test data management(TDM) tools such as Info sphere Optim TDM, CA TDM

• Validating data masking using compare jobs.

• Use IBM Optim Manager to execute the Optim services.

• Custom masking with Lua (Create named Procedure, Local procedure)

• Discover test data and test data provisioning approaches using demonstrated experience in data architectures, data development and administration

• Data profiling, cleansing, sub setting and validation and ETL of production copy data to test systems

• Identify and mask sensitive test data to meet data governance and security requirements and business data rules of integrated systems

• Data Ingestion will be the part key part of the overall Data Seed Hub Architecture. Data Ingestion process will be responsible for below activities

• Determining successful file copy from source

• Validating files details with Registry

• Handling failure condition and sending notifications

• Managing SPAM directory

• Generate production like fabricated test data that meets complex business data rules of integrated applications

Client: Anthem

Duration: Oct 2015 – July 2019

Role: TDM Engineer

Responsibilities:

• Actively participate in the Design, Build, Test, and Deploy phases of implementations for Oracle customers.

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, FTP Server, Excel, DB2 and SQL 2012).

• Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes, if SSIS packages extract row from DB2 to CDC DB, or any insert, update or delete rows in dimension or fact tables in DW.

• Responsible for TDM implementation across De-care and interact with respective stakeholders for data analysis and current BAU processes.

• Responsible for building data profiling, masking framework, running TDM jobs, and provide the masked data to QA team

• Responsible for building the canonical model post data masking process.

• Interact with tool partner in providing a customized solution framework with the best pricing options for clients.

• Interact with Account PoC’s and QEA teams to understand their TDM challenges, capture data points related to scope, analyze data points and propose technical solution for the same.

• Propose solutions including TDM Approach, Plan, Estimates, Assessment approach, implementation of TDM standards, maturity roadmap details for TDM implementation.

• Providing effort estimations, RACI, plan timelines as part of proposal submission

• Priorities quick fix, mid-term fix and long-term fix based on business demand

• Define test data governance approach

• Define team structure and delivery model

• Provide assistance to the data team in conforming to the standardized processes

• Interacted with Business Analysts and Users in requirement gathering, built complex queries using SQL

Environment:

SQL Server 2012/2008/2008R2 Enterprise Edition, VB Script, ASP.NET,XHTML, XML, MS SQL Query Analyzer, SQL Profiler, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Tableau.

Client: Wipro, India

Duration: Dec2013 – Nov 2014

Role: SQL Developer

Responsibilities:

• Actively participate in the Design, Build, Test, and Deploy phases of implementations for Oracle customers.

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, FTP Server, Excel, DB2 and SQL 2012).

• Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes, if SSIS packages extract row from DB2 to CDC DB, or any insert, update or delete rows in dimension or fact tables in DW.

• Filtered data from Transient Stage to EDW by using Complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity.

• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, FTP Task Package Execution task to achieve business needs.

• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.

• Developed SSIS Packages to move data from one database of a server (Partner) to another (CRM) using Web Services Call.

• Created SSIS 2012 Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.

• Developed complex Stored Procedures to generate various Drill down Reports, Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.

• Responsible for creating partition function and schema for the table partitioning.

• Wrote and modified various Stored Procedures used in the application using T-SQL.

• Used SQL Server Profiler to trace the slow running queries and the server activity.

• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent.

• Involved in creating counter logs and trace logs for advanced performance analysis and data logging.

Environment:

SQL Server 2008/2008R2, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual Studio.Net 2008 (C#.NET), ASP.NET, Web service.

Contact this candidate