SUMMARY

• Over 7 years of IT experience as a MS SQL Server Developer 2008/2005/2000 in various Industry verticals like Insurance, Travel agency, Pharmaceutical, Retail, Bank.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Extensive experience in Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services, and MS SQL Server Analysis Services.
• Experience in Logical and Physical Database design & development, Normalization and Data modeling using Erwin data model.
• Highly proficient in using T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Proficient in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
• Extensive experience working with BCP, SSIS packages, creating jobs and linked servers for MS SQL Server/Oracle/ Sybase databases.
• Expert in Creating, Configuring and Fine-tuning MS SQL Server Integration Services (SSIS).
• Skilled in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Extensive experience in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008/2005.
• Experience in Design and optimization of OLTP, OLAP tools, creating SSAS based OLAP Cubes.
• Strong experience in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.
• Experienced in writing MDX queries to work with cube data’s.
• Proficient in using tools like MS SQL Profiler, Database Engine Tuning Advisor, Windows performance for monitoring and tuning SQL Server performance.
• Maintained positive communications and working relationships at all business levels.

TECHNICAL SKILLS

• MS SQL Server 2008/2005/2000/7.0
• MS SQL Server 2008/2005 Analysis Services (SSAS)
• MS SQL Server Integration Service (SSIS)
• MS SQL Reporting Services (SSRS)
• Microsoft Access 2000/8.0
• Microsoft Excel
• Outlook
• MS SQL Profiler
• SQL Query Analyzer
• Database engine tuning advisor
• Erwin Data Modeler 7.2/4.2/4.1
• Excel VBA
• Crystal Reports 8.5
• T-SQL
• MS Visio 2005
• Windows 2003/2000 Advanced Server/Professional
• Windows NT 4.0 Server/Workstation.

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, Maryland

MS SQL Server Developer/SSIS/SSRS Developer

Responsibilities:

• Planned, Defined and Designed data based on business requirement and provided documentation.
• Gathered data and documenting it for further reference.
• Designed Database using Erwin data modeler.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Cache Transform, Conditional Split and Derived column etc.
• Developed SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document.
• Developed SSIS packages using Fuzzy Look Up and Fuzzy Grouping for data cleansing purpose.
• Used SSIS Variables for storing the values which are used in various components of Data Flow Task.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Created the Load packages for loading the CSV files from DB2 into SQL Server using SSIS 2008.
• Generated parameterized reports, sub reports, tabular reports using SSRS-2008.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Configured the report viewing security for various users at various levels using Report Manager
• Scheduled report and exported in PDF format.
• Fine tuned SQL Queries for maximum efficiency and performance.
• Provided documentation for all kinds of reports and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

Confidential, Atlanta, GA

SQL Developer/BI Developer

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Developed various T-SQL stored procedures, functions and packages.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Used SSIS jobs for importing data from the flat files that brings the data to the application tables.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent in SSAS.
• Working knowledge in Data modeling, creating star and snowflake schemas in SSAS.
• Developed complex calculated members, Named Sets using MDX expressions for specific OLAP reporting requirements.
• Created KPI Objects in line with Requirement Docs in SSAS.
• Optimized cubes for better query performance.
• Aggregated cube with 30% performance for better performance.
• Processed cube to perform incremental updates.
• Created reports by dragging data from cube and wrote MDX scripts in SSRS.
• Generated reports using SQL Server Reporting Services 2008 from OLTP and OLAP data sources.
• Designed and deployed report with Drill Down, Drill Through, Dropdown menu option, Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated Managers and Clients.
• Used Database engine tuning advisor, SQL Profiler for Performance Tuning.

Confidential, Pittsburgh, PA

MS SQL Server Developer/ETL Developer

Responsibilities:

• Designing Data Model and implementing changes in the earlier phase of the project to accommodate business logic and dynamic nature of the front end application.
• Designed and modeled Microsoft SQL Server 2008 data warehouse and data marts, including the modification of existing Microsoft SQL Server 2005 data warehouse and data marts.
• Used SSIS packages to roll our data to Live Tables and to Processing Database.
• Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager
• Configure the SSIS Package for run time Parameters and Config file
• Develop the Documents for Logging/Error Handling for SSIS Packages
• Integrate the SSIS package, converting all existing DTS packages of MS SQL by adding extra SSIS task.
• Schedule Package using SQL Server Job for weekly/monthly basis.
• Used Checkpoint for avoiding re-executes Package from the first task.
• Develop the Slowly Changing Transformation to maintain the Historical Data.
• Handling the errors during data moving and Sequencing the task as per requirements.
• Developed packages using fuzzy task for data cleansing.
• Handling the orphan rows in Dimension and Fact tables.
• Participated actively in analysis and discovery phases of data warehouse implementation.
• Perform T-SQL tuning and optimizing queries for Reports which take longer time in execution SQL Server 2008.
• Developed interface and reporting stored procedures, views, UDF for efficient data storage and manipulation
• Migrated some Crystal reports to SSRS reports manually
• XML result set from Stored Procedures to create custom XML file for third party data export.
• Extensive work on SSIS creating all the interfaces between front end application and SQL Server 2008 database, then from legacy database to SQL Server Database and vice versa.

Confidential, San Francisco, CA

MS SQL Server BI Developer

Responsibilities:

• Designed Staging Database using ER-win and SSAS Wizard.
• Involved in requirements gathering, analysis, design, development, change management, deployment.
• Installed and Configured SQL Server 2005 successfully.
• Involved in Login and User Management- Adding logins, roles, groups to the Window NT and SQL Server and maintaining proper security procedures.
• Involved in ER diagrams (Physical and Logical using ERWIN) and mapping the data into database objects.
• Scheduled Daily and weekly Jobs and Alerting using SQL Server Agent.
• Using SSIS package for effective data transfer.
• Developed measures and dimension table using SSAS service.
• Created calculation member and name set using MDX queries for better result in cube.
• Developed KPI’s for business performance.
• Utilized SSRS reporting services to generate different types of reports from the database.
• Performed Data Analysis for automating various Customers Order Reports utilizing SQL Reporting Services.
• Involved in design, programming, deploy and Unit Testing of requested Reports.
• Worked with the Data Architect to migrate legacy data into the new analysis data mart and created reports for inventory module.
• Expertise in Database creation (DDL, DML), database tuning, SQL tuning, performance planning, backup planning and database administration.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration

Confidential, Dallas, TX

Data Warehouse / Report/ ETL Developer

Responsibilities:

• Participated in developing logical model and implementing requirements on SQL Server 2005.
• Created the database for the reporting team.
• Data Migration from Oracle Database and flat files into SQL Server 2005 using SSIS Packages and BCP.
• Solved T-SQL performance issues using Query Analyzer.
• Created and managed schema objects such as Tables, Views, Indexes, Procedures and Triggers.
• Created Backup and Restore operations for migrating database from one server to another.
• Created Database Triggers to implement business requirements.
• Created complex Stored Procedures and Functions to support the front-end application.
• Optimized SQL queries for improved Performance and availability.
• Monitored Strategies, Processes and Procedures to ensure the Data Integrity, Optimized and reduced Data Redundancy, maintained the required level of security for all production and test databases.
• Ensured Data Recovery, Maintenance and space requirements for physical Database.
• Reorganize database structures as needed, automate procedures at regular intervals.
• Optimized long running Stored Procedures & Queries for effective data retrieval.

Confidential 

MS SQL Server Developer

Responsibilities:

• Installed and configured SQL server 2000, created logins, users and maintenance plans managing use of disk memory and connections to the database.
• Carried out a Developer’s role on MS SQL Server 2000, MS Access Databases (using DTS, T-SQL, Stored Procedures and Views).
• Used ER-win, Normalization, Dimension Modeling and Enterprise Manager for Logical and physical database development.
• Imposed Referential Integrity of data by creating different constraints.
• Migration of the data from text files to SQL Server database using BCP and DTS packages for the processing of different policies.
• Managed and Monitored System Utilization.
• Created triggers, stored procedures and functions using T-SQL to implement the business logic.
• Designed and Implemented the Stored Procedures and Triggers for automating tasks.