CAREER PROFILE:

• Senior Data Warehouse Developer
• My career mission is to work in a challenging environment where I aspire for a challenging position in a professional Organization where I can enhance my skills and strengthen them in conjunction with Organization’s goals. A self - motivated achiever with an ability to plan and execute.
• Over 9 years of professional experience in System Analysis, OLTP System Design and development, ETL Design & Development, BI/DW, Data Migration and Client interfacing .
• Experience in OLTP/OLAP System Study, Analysis and ER Modeling, Maintaining Database Schemas like Star Schema and Snowflake Schema used in relational and dimensional modeling.
• Worked extensively in SQL Server 2005, 2008 &2012.
• Worked on tuning areas like Optimizing the SSIS Packages, Optimizing / tuning the databases design and queries .
• Design and develop store procedures, configuration files, tables, and views; implement best practices to maintain optimal performance.
• Extensive knowledge on Data warehousing concepts and Dimensional Modeling.
• Technical Documentation for DW application.
• Agile and Waterfall SDLC Process.
• Proficient in implementing all transformations available on the SSIS toolbox.
• Working with Remote Team.
• Ability to identify skill gaps based on current and anticipated needs has helped me organize training in different technical area for the team members and prepare the team for immediate needs.
• Estimation and tracking.

AREA OF EXPERTISE:

ETL tool: SSIS.

RDBMS: SQL Server, PostgreSQL, Oracle 9i/10g, MS-access.

Data modelling: SSAS

Reporting tools: SSRS.

Languages: SQL server 2014, 2012,2008, T-SQL,java script, HTML, Oracle DBA, Microsoft VB, Microsoft C++,metadata repository.

IDE Tools: BIDS, SSMS, Excel 2010 with Power Pivot, share point, TFS.

PROFESSIONAL HISTORY:

Confidential

SSIS developer

Responsibilities:

• Creating tables, running ETL jobs, writing dynamic scripts to generate stored procedure, creating tables etc..,
• Creating packages in the solution explorer (In EXTRACT, TRANSFORM AND LOAD) and writing SQL query in data flow task, creating variable, error handling process and writing functions.
• Creating project parameters for different regions. And maintaining package logs by SQL server in SSISDB database .query in internal packages table in SSISDB to view execution performance, analyze performance and tracking logging message of the execution.
• Describing environments names from which data is coming.
• Deploying the packages in the solution explorer to catalog which is in management studio.
• Testing the table in DW to load data to catch many errors like data type violation, NULL constraint violation, foreign key violation and duplicate data.
• Generating reports to maintain zero percent error’s in all the data warehouse tables.
• Writing quires to dynamically generated stored procedure, creating table and also catching errors.
• Applied various data transformations like Data Conversion, Multicasting, Conditional Split, Derived column in SSIS.
• Wrote SSIS Packages to migrate user's logins, stored procedures, and functions.
• Involved in designing the SSIS packages to export data from SQL Server database to flat file source.
• Effectively worked in production support and managed the quality assurance for SSIS packages.
• Effectively loaded data into relational database using ETL tool.
• Migration of SSRS reports from SQL 2012 to SQL 2014.
• Designed Graphical and Tablix reports using SSRS.
• Tested different types of reports before moving it to the production
• Wrote SQL queries to retrieve specific information from the database to make sure that the data entered has been up-loaded correctly in to the database.
• Performed SQL Server tools like SQL Performance optimization using SQL Server Profiler and Database Engine Tuning Advisor.
• Used BCP command and TSQL command to bulk copy the data from Text files to SQL Server and vice versa.
• Worked with Team Foundation Server(TFS), perforce as the source for version control and project/issue management

Confidential

Senior developer.

Responsibilities:

• Developing SSIS package based on Business
• Rules Implemented SQL SERVER and XML SSIS configuration.
• Migrating the packages from DTS to SSIS
• Migrating the packages from SSIS 2005 to SSIS 2008
• Writing Complex Stored procedures
• Design and developed various types of SSRS Reports
• Design an SSAS cube for Aggregate Report processing.
• Involved in SSIS Package maintenance.
• Implemented QA database comparison code using SSIS.
• Developed automation tools to improve project productivity. Developed a tool in SSIS and compared two Dimensional database tables or view based on their given column combination and find the duplicate entry in that view or table, also found Null value for the given table and generated an report.
• Developed a tool in SSIS and automated the documentation work as per business rule.
• Worked on Partition Logic for the Detail and Event Segment. This Logic enhanced the performance by decreasing the time taken for processing the data.
• Created Batch code which will find unused tables in the database.
• Created Batch code which will delete file in a given path based on its created age.
• Created Batch code which will replace the DB string with a user define DB name based on position value given on a text file.
• Preparing Dashboard reports based on the performance of servers.

Confidential senior developer

Responsibilities:

• Monitoring the ETL and Reports running in the production environment
• SSRS report related issues hot fix.
• Fixing SSIS packages.
• Fixing oracle - PSQL queries
• All these fixes are done through tickets and will follow the process of QA and then will move to production system.
• Improve and optimize the SSRS report performance by fine tuning the PSQL Queries.
• Tracker excels for resource management and production management.
• Involved in SSIS Package maintenance activities.

Confidential, Tampa, Florida

Senior developer

Responsibilities:

• Involved in Claims Processing Extract and loading to Data Warehouse.
• Involved in the design of the Data warehouse in the Stare schema architecture
• Designing the SSIS ETL packages
• Implementing various staging database and the final warehouse
• Creating SSRS reports out of the warehouse
• Scheduling the package to run on daily basis to get data from the source system
• ETL and Reports Deployment
• Using the share point to maintain the records of the data .
• Writing complex stored procedure to perform logical operations.
• Involved in Planet press design for the document management process like enabling to create new documents regarding the transactional details or enhance existing ones, capturing the data and optimizing the data.

Confidential

DW/ Data Architect, Data Mart Developer

Responsibilities:

• Analyze the requirement and design the high-level user interface and database.
• Designed the applications in the data model using normalization process up to 3NF.
• Identified redundant programming functionality and developed reusable ActiveX controls
• Worked on exporting graphical reports to Excel.
• For version control and sharing file utilized MS Visual Source-safe.
• Implemented query optimization techniques to improve the SQL Performance.
• Development of Stored Procedures as per the given Business Rules.

Confidential onsite lead

Responsibilities:

• Finding solution if any Daily ETL job fails
• Providing permanent fixes for production failures.
• Fixing SSIS packages if any issue found in Production environment, Development:
• Involved in various SSRS report generation
• Involved in fixing any problem in existing reports and stored procedures
• Involved in fixing Physician key fuzzy lookup data issue
• Improve and optimize ETL job’s performance and ensure that the job execution time is reduced
• Data analysis and correction
• Improve performance of SSRS reports
• Involved in SSIS Package maintenance and Scheduling through SQL SERVER AGENT.