SUMMARY

• More than Nine years of experience as ETL/SQL Developer seeking a permanent or consulting position with a promising, growing, stable, prestigious, high tech organization to contribute the value of my diverse technical, business acumen and professional experience in designing, developing, implementing and executing Database development based on Specifications in a Web based, and Client/Server while offering me a challenging milieu of opportunity and growth.

TECHNICAL SKILLS

Databases: Microsoft SQL Server 2008, 2012, 2014,2017 Oracle 11i/10g/9i, Active Directory, MS Access.

Operating Systems: Solaris, Unix, Windows 10/XP/2000/NT/98/95, DOS

Data Migration Tools: SSIS

Applications: MS Office, Visio, Norton Utilities, Anti - Virus software.

Browser: Internet Explorer, Netscape.

Reporting Tools: SSRS and Power BI.

Communication: FTP, TCP/IP, Telnet.

Application Server: WEBLOGIC, APPACHE, IIS

Languages: Python, Visual Basic

Scripting Languages: VB Scripts, Unix Shell Scripts, SQL, PL/SQL

Others: PVCS Tracker, Rational Clear Quest, Requisite Pro, Clear Case, UML, HTML, DHTML, SQL Developer, MSMS, TOAD, Power Point, AWS RDS, SQL Loader, BitBucket.

PROFESSIONAL EXPERIENCE

Confidential, Bethesda, MD

Senior Sql Developer

Responsibilities:

• Catch and participate all necessary business & application related meetings to understand the system in order to generate technical solution to a business problem with SQL Server, SSIS technology stack.
• Created source to target mappings and ETL design for integration of new/modified data streams into data warehouses.
• Frequently used SSIS transformation such as Execute SQL task, For Each Loop, Expression, Dynamic Connection Manager, Lookup, Merge Join, Aggregate, Conditional split, Script Task.
• Fabricated SSIS variables for storing the value, which are used in various components of the Data Flow Task.
• Deployed project & packages, created environment variables, used SSIS Catalog & schedule jobs in SSISDB.
• Created database objects- tables, indexes, views, stored procedures and user defined functions according to the requirements of the project.
• Developed large & complex SQL query to load data from stage to output accordance with business logic.
• Extensively worked Data Quality task to addressed various issues encountered from production server, application, administrative backend reporting.
• Designed parameterized SSRS reports and developed data sets, queries for respective reports.
• Created and updated Talend jobs using Talen Studio.
• Identify problems, develop ideas and proposed solution within differing situations requiring analytical, evaluative or constructive thinking in daily work.
• Performed all phases of unit testing to ensure that designed packages as well as target output meet requirements.
• Used TFS server for Source Control, Versioning, Branching.

Environment: MS SQL Server 2017, Windows 10, MS Visual Studio 2017, MS Excel 2016, MS Access 2016, Talend, TFS, AZURE.

Confidential, St Louis, MO

ETL Developer

Responsibilities:

• Attended business meetings to understand the requirement and articulate technical solution to a business problem with SQL Server, SSIS technology stack.
• Prepared source to target mappings and ETL design for integration of new/modified data streams into data warehouses/data marts.
• Extensively used SSIS transformation such as Execute SQL task, Expression, Dynamic Connection Manager, Lookup, Derived column, Data conversion, Aggregate, Conditional split, Script Task
• Created SSIS variables for storing the value, which are used in various components of the Data Flow Task.
• Designed SSIS reusable packages to extract data from multi formatted flat files, excel, xml.
• Created database objects- tables, indexes, views, stored procedures and user defined functions according to the requirements of the project.
• Developed large & complex SQL query to load data from stage to output accordance with business logic.
• Created multiple parameterized stored procedure which are used to generate report as well as daily uses for task purpose.
• Identify problems, develop ideas and proposed solution within differing situations requiring analytical, evaluative or constructive thinking in daily work.
• Performed all phases of unit testing to ensure that designed packages as well as target output meet requirements.
• Cloned project from repositories, created branches to respective JIRA ticket, sync, resolve code conflict and then merged feature branch to development branch using VS Team explorer.
• Created pull request, approved pears pull request with reviewing the code changed using BitBucket.
• Tested peer’s packages accordance with test script as well as used power shell to generate report.

Environment: MS SQL Server 2014, Windows 10, MS Visual Studio 2017, MS Excel 2016, MS Access 2016, Teradata 2015, Jira, BitBucket.

Confidential, New York, NY

SQL Developer

Responsibilities:

• Attended business and client requirement walkthrough and review, and prepare the functional user stories.
• Studied system and architectural design, implemented customer specific changes in the standard product development functionality
• Analyzed as well as involved in update/remodel of the Database design.
• Estimation of the different modules/phases of project.
• Involved in Creation of Instance, Databases in AWS environment.
• Worked on database creation, planning, design, data modeling, and entity relationship using ERWIN
• Implemented transformation using SSIS to migrate data from different sources to SQL.
• Created, developed implemented and maintained various database objects such as Tables, Views, Indexes, User defined functions, Triggers, Stored procedure, Constraints and Roles.
• Wrote complex T-SQL scripts to generate objects to synchronize database.
• Designed and populated specific tables, databases for collection, tracking & reporting of data
• Implemented table partition for very large table to improve query performance.
• Reorganized and rebuilt indexes based on fragmentation to improve performance of data retrieval.
• Teamed up with developer and tester to verify SQL code from frontend to back end and redesigned the SQL code as needed.

Environment: MS SQL Server 2008 & 2012, Windows 8/XP, Linux, MS Visual Studio 2015, MS Excel 2013, MS Access 2013,MS Power point, Oracle 10g, Power BI, Jira.

Confidential, Columbus, Ohio

ETL Developer

Responsibilities:

• Liaised with project management and development team to identify and implement reporting, control & automation opportunities to improve overall access to information.
• Assisted new and existing clients with integration and data conversion activities.
• Engaged in implementation team to implement various subject areas like ENCOUNTER, ENCOUNTER BILL SUMMARY, APPOINMENT SCHEDULING, READMISSION, INFECTION CONTROL, PATIENT SAFTY, REVENUE CYCLE
• Coordinated with technical & operational teams to prepare and integrate multiple data sets in various formats to provide insight into Exchange operation
• Involved with Implementation/Product development/ Customer Solution teams to ensure efficiency of the analytical solution of “Knowledge|Edge™”
• Created SSIS packages to perform day to day ETL task including data cleansing, loading flat files into the warehouse
• Used various SSIS task such as Aggregate function, Conditional split, data conversion, union all.
• Efficiently worked with SQL Bulk insert and BCP for data transformation using command prompt.
• Participated in daily, weekly, monthly and other technical meetings to provide status & input as needed.
• Involved in captured issue, defect and create story, defect into Version One

Environment: MS SQL Server 2008 & 2012, Windows 8/XP, Linux, MS Visual Studio 2015, MS Excel 2013, MS Access 2013, Oracle 10g

Confidential, Brooklyn, New York

SQL Developer

Responsibilities:

• Meet with customers to understand the need and wrote requirements and review with them.
• Analyzed the Business requirement (FRD) Functional Requirement Document and Design documents standard procedures followed to develop
• Continuously interacted with project managers, development teams, testing teams, and subject matter experts to review business requirements and design specifications.
• Reviewed physical and logical database design; Promote the reliability of database design by ensuring appropriate referential data integrity is implemented as well as appropriate data type are used.
• Worked on logical and physical database modeling with ERWIN tools.
• Created database object tables, indexes, views, constraints, roles, users.
• Wrote complex T-SQL/PLSQL, Dynamic queries, sub-queries, complex join to generate user defined function, stored procedures, triggers.
• Implemented trigger & stored procedure and implemented business rules via check and constrained.
• Developed and deployed data transfers packages to the appropriate destination using SSIS.
• Reviewed DB scripts from the development team before releasing them into production.

ENVIRONMENT: MS SQL Server 2008 & 2012, Windows 7 & Vista, ERWIN Data Modeler, MS Excel, MS Power Point, Linux. Visual Studio 2008, MS Word.