OBJECTIVE

• To associate with a progressive organization that offers to work on current trends and technologies. The scope of opportunities may also be useful to update knowledge and skills in accordance with the latest trends. I would like to be a part of the team that dynamically works towards the growth of the organization.

SUMMARY

• Above 6 years of strong experience in the IT industry as a Data Analyst/SQL Developerand experienced in Banking, Healthcare and Insurance domains.
• Proven ability in working with enterprise level large data warehouses, RDBMS systems, and ETL and modeling tools/techniques.
• Worked with different source systems like Oracle 10g and Microsoft SQL Server. Thorough knowledge and understanding of Dimensional Data Modeling, Star schema, Snow - Flake schema, creation of Fact and Dimension Tables, OLAP, OLTP and other Data-Warehousing concepts.
• Extensive knowledge in ER Diagram and design of logical and physical data modeling using Erwin tool and Visio.
• Extensive experience in creating and using Stored Procedure, Views, Triggers, schemas and Complex queries onSQLServer.
• Well versed with data movement and data conditioning within cross platforms.
• Extracted data from existing data stores, Developing and executing departmental reports for performance and response purposes by using oracle SQL, SAS, procedures, packages, functions, database triggers
• Skillful in Informatica Master Data Management (MDM) to extract, transform, load (ETL) data on Oracle Database Management.
• Excellent analytical skills for understanding the business requirements, business rules, business process and detailed design of the application
• Extensive experience in System Development Life Cycle (SDLC) involved in all stages of development including elicitation, analysis, specification, design, implementation, testing and deployment of applications.
• Experiencedin creating SSIS packages to import/export data toSQLServer from various sources like Excel, Text, XML, Access and Oracle using different transformations like conditional split, Sort, merge join, and derived column.
• Hands on experience in developing Custom, Tabular, Matrix, cascading parameters, drill though, drill down, cross tab, sub, and Adhoc reports using SQLserver Reporting Services (SSRS).
• Experience in Data Scrubbing/Cleansing, Data Quality, Data Mapping, Data Profiling, Data Validation in ETL.
• Participated in requirements analysis reviews and Design sessions to understand the requirements and designing Reporting Solutions.
• Experience to coordinate and interact with internal and external stakeholders in the project like Operation group, Production group, Change Management group, Third party vendors, Management support group, Business Analysts group, IT group, User Acceptance group.
• Committed team player, with excellent communication skills and self-starter, capable of working independently. Good problem solving skills, attention to detail, better initiative and judgment. Good business understanding and effective at working across multiple teams within an organization.
• Excellent written and oral communication skills; highly result-oriented.

TECHNICAL SKILLS

• MS SQLServer 2012/R2/2008/2005
• MySql
• C++
• VB
• CSS
• PHP
• HTML python
• SPSS
• Shell scripting
• Microsoft Windows 98
• XP
• Vista
• 2007/08
• Windows 2003 Server
• Linux
• Unix
• MS Office Suites
• UML
• Rational Rose
• Microsoft Visio.

PROFESSIONAL EXPERIENCE

Confidential, Hartford, CT

Data Analyst/SQL Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• UsedSSISandT-SQLstored procedures to transfer data fromOLTPdatabases to staging area and finally transfer into data warehouse.
• Used various SSIS tasks such as Conditional Split, Derived Column, look up, etc for Data Scrubbing, data validation checks during Staging, before loading the data into theData warehouse.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Experience in creating Jobs, Alerts,SQLMail Agent, and scheduleSSISPackages.
• CreatedSQLserver configurationsforSSISpackages.
• Responsible for creating reports based on the requirements using SSRS 2012.
• Identified the database tables for defining queries to generate reports for analysis of data usingSQLServer Reporting Services.
• Defined the report layout and identified Datasets for report generation.
• Created different type of reports including Cross-tab, Drill through, Drill-down, Sub reports, and parameterized reports.
• Extract Transform and Load (ETL)source data into respective target tables to build the required datamarts.
• Created numbers of complex formula in sub report.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Developed and implemented procedures to ensure the quality, usability and accuracy of reports.
• Implemented Star Schema for OLAP cubes using SSAS.
• Created Packages to group logically related column types and to transfer data.
• Involved in designing logical and physical data models.
• Documented and delivered Functional Specification Document to the project team by using SQL Server.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing transformations using SSIS packages
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS).

Confidential, Whitehouse Station, NJ

SQL Developer/ Data Analyst

Responsibilities:

• Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints, Stored Procedures and Queries to be used in the project.
• Optimizedthe performance of queries with modification in T-SQL queries,creating sub queries, establishing joins and creatingindexes wherever necessary.
• Worked on Huge Data Transfers from & toSQLServer Databases using utilities / tools like SSIS, BCP, BULK INSERTetc.
• Developed, monitored and deployed SSIS packages for ETL flow tovalidate, extract, transform and load data into database.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• CreatedSQLserver Analysis Projects;createdMultidimensional databases /cubes/, facts and dimensions for the analysis ofproductsin specific areas using SSAS.
• Developed SSIS ETL packages to meet data flow needs, automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
• Deployed analysis projects using SSAS based on data volume, as well asdeveloped of KPI's which helped the Business users for easy understanding.
• Design and Developedmultiple Enterprise reports using SSRS fromboth OLTP andOLAP databases
• Developed MDX expressions for cube calculations and KPIs.
• Executed different Ad-hocreports usingMSSQLSSRS.
• Documented and delivered Functional Specification Document to the project team by using SQL Server.
• Tested the reports and fixed bugs in the stored procedures.Involved in scheduling the reports and setting security for reports.
• Administered interface to organize reports and data sources, schedule report execution and delivery,and track report history using SSRS.

Confidential, Minnetonka, MN

Data Analyst/SQL Developer

Responsibilities:

• Gathered requirements from various sources.
• Translated the business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Developed SSIS packages to Extract, Transform and load data to Data warehouse with different data flow transformations such as conditional split, multicast,dataconversion, sort, aggregate, merge, derived column, etc.
• Created SSIS packages to migrate the data from Oracle 8i,SQL2000 toSQLServer 2008.
• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• CreatedSQLserver Reports using SSRS 2008 for the management to take strategic decisions.
• Designed and created Report templates.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Defined user roles and created subscriptions on reports.
• Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
• Generated reports inSQLServer 2008 and deployed them on the local host for remote access.
• Administered SSRS data sources, reports and models.

Confidential, Irvine, CA

SQL Developer/Data Analyst

Responsibilities:

• Upgrading SQLServer 2008 with latest Service packs like SP2.
• System maintenance tasks such as Database Backup and Recovery, Database mirroring and replication.
• Extensively involved in replication and implemented Snapshot, Merge and Transactional Replications.
• Maintained data integrity by developing bug/data fixes.
• Designed the highest level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS 2008.
• Used Bulk Copy Program (BCP) to import and export large amount of datain and out ofSQLServer Databases.
• Created Alerts for successful or unsuccessful completion of scheduled Job.
• Identified Key Performance Indicators for Business needs in SSAS 2008.
• Worked with OLTP, OLAP, Data warehouse application, star schema and snowflakes schema dimensions.
• Defined report layouts including report parameters and wrote queries for different kinds of reports using SSRS 2008.
• Created, tested and administered various types of reports: drill-down, drill through, parameterized, sub-reports, ad ad-hoc reports.
• Created subscriptions to deliver the reports in a timely manner usingSQLServer Reporting Services.