Data Sql Server

SUMMARY:

An enthusiastic Data warehouse professional with drive and commitment to resolve data warehouse issues.

Have a total 3 years of experience in software development and expertise in ETL development using Informatica, SSIS, PL/SQL, Oracle, MS SQL, data analysis, Microsoft Excel and Microsoft Access.

Passionate about exploring data warehouse skills, solving complex problems, committed to my work and offer prompt communication.

Ability to beat deadlines without compromising quality.

TECHNICAL SKILLS:

Data warehousing: Informatica PowerCenter 9.1, 9.5,9.6.1, SSIS, SSRS

Dimensional Modelling: Sybase PowerDesigner 16.5

Databases: Oracle 10/11G, MS SQL Server 2005, 2008, 2012, 2014, MS Access, MS Excel, Agility Netezza Workbench

Programming/GUI: SQL, T-SQL, PL/SQL, C#, ASP.net, HTML5, UNIX

Project Development Methodology: SDLC, Waterfall, Agile

Project Management Tools: JIRA, HP Quality Center

Scheduling Tools: Autosys, SQL Server Management Jobs

PROFESSIONAL EXPERIENCE:

Infosys, Technology Lead April 2015-Till Date

Reg W Compliance project is to analyze the transactions in Global Markets, Global banking, Corporate Treasury and Global Wealth Investment Management are complying to the Federal law regulations.

Created Data Request Memo to request data from Source Systems.

Gather the requirements from Source system.

Developed Business Requirement Document.

Develop SSIS packages for loading data from different sources to SQL server database.

Transformed data according to the requirements.

Schedule jobs via SQL server jobs agent.

Written complex SQL queries to perform data analysis.

Generated reports using SSRS.

Developed Data documentation documenting the entire analysis from the scratch.

Working closely with the Compliance testing team to check the requirements are matching.

Banking Sector:

The Vendor Analytical Data Warehouse(VADW) project comprises of several integration several stove pipe databases into a single unified enterprise data repository. Applications including ARIBA, POWER, RDR, etc. were integrated in the VADW.

Created Design documents

Worked closely with the data architect on the data model for building the EDW.

Developed ETL stage mappings to extract the data from the source system to the staging area.

Developed EDW mappings based on the System Module Specifications

Analyzed stored procedures in the source system to replace the stored procedures with ETL mappings

Co-ordination with Micro strategy developer to get the report built

Mapping and Workflow development, Unit Testing and review walk through with Users

Scheduling via Autosys

Co-ordination with testing team and support team for deployment across various environments

Data Modelling and Data Warehouse Development:

Worked closely with the Business analyst to gather requirements.

Designed Data Model using Sybase PowerDesigner suitable for Netezza database

Developed High Level and Low Level Design documents from Business Requirement Document.

Involved in creating mappings/reusable mapplets and arranging sessions in workflows while scheduling the jobs and trigger set ups.

Optimized the ETL process using Performance Tuning Methods in Informatica mappings. Tuned mappings and SQL queries for better performance and efficiency.

Used pmcmd command in UNIX to kick off Informatica workflow from UNIX environment.

Implemented SCD type 1 and type 2 dimensions.

Setup Autosys jobs to looks for trigger files to schedule the load process.

Worked closely with System Integration team.

Worked very closely with User Acceptance Testing team to implement changes to meet end user requirements.

Coordinated with Production Support team for releases.

Geisinger Health Plan, Danville, PA Sep 2014- Feb 2015

ETL Developer

Health Centre: The primary intent of the project is to provide the business with the means to provide operational efficiencies by having a single source for Health department. I combined data from the wellness client and Health Centre systems into one central repository. Increased reports and the analytical capabilities. The business has reviewed all Health Centre canned reports and prioritized their interest. This project is expected to automate the extract, mapping and loading of data from Health Centre into our EDW.

Analysis, Requirements gathering, function/technical specification, development, deploying and testing.

Involved in the Design, Development, Testing phases of Data warehouse.

Logical and Physical Database Layout Design using Sybase PowerDesigner and Involved in Design and Data Modeling using Star schema.

Created Informatica mappings for initial load and daily updates.

Involved in fixing invalid mappings, testing of stored procedures and functions, unit and integration testing of Informatica Mappings, Sessions, Workflows and the target data.

Developed several mappings to load data from multiple sources to data warehouse.

Developed, tested Stored Procedures, Functions and packages in PL/SQL for Data ETL

Performed Data conversions.

Involved in troubleshooting the load failure cases, database problems.

Extensively used mapping parameters, mapping variables and parameter files.

Environment: Informatica Power Center 9.1, Oracle 10g, Erwin, UNIX Shell Scripts, TOAD, SQL * Loader, Windows NT.

Illinois Department of Natural Resources, SPR, IL

Information Technology Analyst AUG 2013 – JUN 2014

Project: Created a Web Application for registration/renewal of hunting licenses Visual Studio 2010

Designed web application using ASP.net server controls, CSS and HTML Server Controls

Used ADO.NET to capture user input from the registration form and store it in SQL Server tables

Used ADO.NET to query the data from SQL server to display to the user

Developed a number of modules that validated user entered data

Used SMTP to e-mail license administrator notifying changes made by the user to his/her account

Developed code to transfer appointment details from flat filets to SQL Server tables and vice versa.

Used Code-Behind model to display label text on web pages

Environment: Visual Studio 2012, ASP.net, C#, HTML 5, CSS

PROJECTS:

Created a Web Application (University of Illinois at Springfield) using Visual Studio 2012:

Developed University of Illinois Web application with dynamic web pages where the user can login and search as per the user’s requirement.

Using ADO.net established linkage between web application and MS Access.

Repository for Placement Cell Database Project:

Created a webpage using HTML.

Established JDBC linkage to webpage and SQL server where the database stores data in the form of files and tables supporting the application.

Internet-based Database Management System for Project Control:

Coordinated in general project design.

Responsible for creating ERD diagram after team decision on what database should include.

Responsible for creating and updating Object Model diagram and relational database schema.

Created tables in database, added data to database, reviewed problem statement/requirements definition and updated scenarios and event trace diagrams.

Coded PL/SQL Packages, functions and procedures incorporating complex business rules and functionalities.

Used PL/SQL collections, bulk operations to load data.

Have composed several SQL queries to retrieve data fast from multiple tables.

Documented all the procedures and functions involved in the process.

Developed scripts to create the DDLs and migrated data from one schema to another, ensuring data integrity and accuracy.

Website for Bio Club Management:

Designed a website for the Department of Biotechnology at JBIET for an event using HTML and CSS

EDUCATION:

Masters of Science (Computer Science), University of Illinois at Springfield

CERTIFICATION:

Oracle 11g SQL certification.

REFERENCES:

On request.

Contact this candidate