SUMMARY:

• Over 7+ years of the extensive experience in IT Professional with Database design, development, deployment and support in various domain such as Finance, Insurance, Pharmaceutical and Retailing.
• Expert in Business Intelligence tools like MS SQL Server Reporting (SSRS), MS SQL Server Integration Services (SSIS) and MS SQL Server Analysis Services (SSAS) in 2005/2008.
• Experienced in designing high level ETL architecture, creating, configuring and fine tuning ETL workflows designed in DTS for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2000/2005/2008, Oracle Pl/Sql.
• Expert in creating Entity - Relationship Diagrams and Data Flow Diagrams.
• Involved in the phases of the Software Development Life Cycle (SDLC).
• Good experience of developing Drill down Reports, Parameterized with query and report parameters, Cascading Reports, Sub Report and Filtering Reports.
• Expertise in integrating packages using aggregate function, sorting and samplings.
• Highly proficient in developing complex stored procedure, Function, Triggers, Views, SQL joins and query writing.
• Experienced in logical and physical database design and development.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries
• Created and Designed a Multi Dimensional Analysis (Configured OLAP Cubes, Dimensions, Measures, MDX Queries, Data mining, Data Source and Data Source Views and Star and Snow Flake schema) using SQL Server 2005 Analysis Services (SSAS), worked on teradata.
• Knowledge in query optimization & performance tuning, Using SQL Server Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Hands on Experience in using tools like Dynamic Management Views, Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for Monitoring and Tuning SQL Server Performance.
• Experience working in a clustered OLTP environment with Very Large Databases (VLDB) and having version control (Visual SourceSafe and Team Foundation Server).
• Expert in multi-terabyte databases/ data-warehouses, web applications in Finance & CRM domains
• Good SQL Server Administration skills using various backup recovery, replication, restoration and DTS servers, Model (simple, Bulk and full), database maintenance plan.
• Efficient in up gradation and migration from SQL Server 2000 to SQL Server 2005/2008.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools
• Experience in maintaining SQL Server security by assigning logins, server, database roles and server permissions.
• Knowledge on Web Programming using JavaScript, HTML, XML and CSS

TECHNICAL SKILLS:

Technologies: MS SQL Server 2008/2005/2000/7.0, MS SQL Server 2005/2008 Analysis Services (SSAS), MS SQL Server Integration Service (SSIS), MS SQL Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), Bulk Copy(BCP), SQL Profiler, Enterprise manager, Management studio, Microsoft Access 2000, ERWIN 4.0/4.1/4.2/7.2, teradata, Microsoft Visio 10.0/11.0, T-SQL, ASP.NET, C#, VB.Net, HTML, XML, XSL, Oracle 9i/10g, Crystal Reports 8.5/9/10/11, Visual source safe 2005, MS office 2003/2007, Windows 2000/2003 Advanced Server/Professional, Windows NT 4.0 Server/Workstation.

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

SSIS/SSRS Developer

Responsibilities:

• Actively participated in gathering Business Requirements and System Specification from system users.
• Efficiently involved in developing physical and logical design of database, incorporating new business requirements, and implemented the new design into SQL Server 2008.
• Created new tables, written stored procedures for Application Developers and some user defined functions, indexes, views etc.
• Designed ETL process to load data from different sources like text file, excel or various database. Performing migration of the data from text file or database to staging and from staging to data warehouse.
• Applied business logic on staging database. Also we save clean and corrected data for the further use.
• Designed expense report with the use of the fact and dimension table model. Also, designed the aggregate table for the usage summary reports.
• Defined parent and child relationship by using common table expression.
• Using a slowly changing dimension to load the data in to DW and maintain the historical data. Using different control such as for loop container, lookup, merge, union all,
• Responsible for the design of the SSIS package for the updated expense amount from OLTP database.
• Maintained nightly and weekly data loads by scheduling the corresponding ETL job in SQL Server Agent.
• Created subscription for the windows file share and implemented three layer securities for the reports in SSRS.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created Cross-Tab, Drill-down and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Optimized queries and did performance tuning using various MS SQL Server tools such as SQL Profiler, SQL Performance Monitor and execution Plan and Index Tuning wizard.
• Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
• Tested the reports and fixed bugs in the stored procedures.
• Involving in installation and upgrade of Microsoft SQL Server and also manage security roles in MS SQL Server.
• Validated reports to ensure quality of data and conducted Meetings with business users to review reports and obtain continuous feedback.
• Coordinated the activities of subordinates in the Team and organized weekly status Meetings.

Environment: SSIS, MS SQL Server 2008, Windows server 2003/2008, VB.Net, Query Analyzer, SQL Profiler, Index Tuning Wizard,, MS Access, MS Excel, SQL Server Business Intelligent Development Studio

Confidential, Solon, OH

SSIS/SSRS Developer

Responsibilities:

• Actively involved as a part of a team for gathering and analyzing the User Requirement.
• Updated functional specification and technical design documents.
• Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions.
• Defined parent and child relationship by using common table expression.
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
• Designed, developed and deployed complex SSIS packages based on STTM (Source-To-Target-Mappings) conversion rules for the transformation of systems to subsequent target layers in MS SQL Server 2008.
• Created ETL SSIS packages both design and code to process data to target databases and to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis.
• Validated and modified the data using different Data Flow Transformations like Send Mail, Web Services, File System Task, Conditional Split, Lookup, Term Extraction, Pivot, Multi-Cast, Derived Column, Audit, and Data Conversion etc.
• Worked with different Control Flow elements like sequence container, execute SQL task, For Loop Container, for each Loop Container etc.
• Scheduled the SSIS packages to run at different intervals to load the data into SQL Server.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs. Using other tools such as event handler, Logging in etc
• Involved in design, developing and implementing the logical and physical model for Data mart.
• Involved in preparing detailed technical documents.
• Coordinated the activities of subordinates in the Team and organized weekly status Meetings.
• Participated in requirement gathering, cube design, application design, SSAS development, operational users.
• Involved in partition of the cube to resolve the production issue.
• Created Linked Servers to retrieve data from other databases.

Environment: SSIS, MS SQL Server 2008, Windows server 2003/2008, Query Analyzer, SQL Profiler, Index Tuning Wizard,, MS Access, MS Excel, SQL Server Business Intelligent Development Studio

Confidential, Greenville, SC

SSRS/SSIS/SSAS Developer

Responsibilities:

• Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data using Erwin.
• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations.
• Designed DTS Packages to transfer data between servers, load data into database, archive data file from different DBMS using SQL Enterprise Manager on SQL Server 2000 environment, and deploy the data, scheduled the jobs to do these tasks periodically.
• Analyzed database performance with SQL Profiler and Optimized indexes to improve query performance.
• Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints
• Scheduled tasks to run every day to update changes in the base tables
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 in Business Intelligence Development Studio (BIDS)
• Extracted the data from Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS (SQL Server 2005)
• Involved in the Migration of Databases from SQL Server 2000 to SQL Server 2008.
• Prepared the complete data mapping for all the migrated jobs using SSIS
• Involved in Performance tuning of ETL transformations, data validations and stored procedures.
• Customized the CRM application for the business by adding custom tables, scripting,.
• Designed and developed various types of reports using SSRS and rendered them in front end applications like Excel and .net.
• Performed data cleansing by creating tables to eliminate the dirty data using SSIS
• Performed daily tasks including backup and restore from disaster recovery by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP
• Designed and created distributed reports in multiple formats such as Excel, PDF, XML, HTML and CSV using SQL Server 2005 Reporting Services (SSRS) and Crystal reports.
• Prepared the complete data mapping for all the migrated jobs using SSIS
• Experience in performance tuning, query optimization, Database Maintenance plans, Database Consistency Checks using DBCC

Environment: SQL Server 2005/2008, MS Access DB, SSIS, SSAS, SSRS, Erwin, .Net Frame Work, XML, MS Access, Excel, Share point (MOSS), C#, ASP .Net, VBA, Crystal Reports, ER Studio.

Confidential, Richmond, VA

SSIS/SSRS

Responsibilities:

• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created and when required, modified already existing stored procedures, triggers, views, indexes.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Tested queries to optimize the procedures and triggers to be used in production.
• Migrated DTS package in to SSIS using SQL server integration services 2008.
• Design Reports Using SQL Server Reporting Services (SSRS) identified the database tables for defining the queries and defined datasets for report generation.
• Generated reports using Variables, Expressions and Functions based on the requirements using SSRS 2008.
• Defined reports layouts including report parameters and wrote queries for drill through reports as per client’s requirements using SSRS 2008
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS.
• Generated daily, weekly and monthly reports for the managers.
• Administered interface to organize reports and data sources, schedule report execution and delivery and track reporting history SSRS 2008.
• Tested the reports and fixed bugs in the stored procedures.
• Maintained the physical database by monitoring performance, integrity and optimized SQL queries for maximum efficiency using SQL Profiler.
• Performed Performance tuning and optimization of SQL queries using SQL profiler and query analyzer.

Confidential, jersey city-NJ

SQL Server/Analyst

Responsibilities:

• Implemented Complex Logging in SSIS Packages.
• Used various transformations in SSIS like Lookup, Fuzzy grouping, Row count Transformations.
• Played role in design of scalable, reusable, and low maintenance ETL templates.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 slowly changing dimensions.
• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created SSIS/DTS packages for Finance application that would transfer data among servers and perform other data transformations; scheduled the same SSIS packages by creating the corresponding job tasks.
• Performed ETL operations for Business Intelligence reporting solutions using custom VBA and Excel web queries
• Generated parameterized/Drilldown reports using SSRS and Crystal Reports.
• Created Report Snapshots to improve the performance of SSRS.
• Used dynamic parameters in SSRS to enable/disable the parameters based on user selection
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services.
• Identified the dimension, fact tables and designed the data warehouse using star schema
• Used Script Logic Quest Lite Speed dramatically to reduce storage costs by quickly compressing data up to 95%.
• Migration of an MS Access application to SQL Server 2000.
• Created named query in SSAS Data Source View to get appropriate hierarchical summarize data for two dimensions.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Created Perspectives of the cube to simplify the process of browsing for the end users.
• Used MDX to create calculated members in the cube.
• Used to support the data processing engine in database intensive operations like query Performance tuning, parallel query algorithm, and data mining by writing stored Procedures

Environment: Microsoft SQL Server 2005 Enterprise Edition, T-SQL, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, MS visio, Windows server 2003 and IIS 5.

Confidential, Jacksonville, FL

Jr. SQL Server Developer

Responsibilities:

• Involved in designing the physical databases model on SQL Server 2005 RDBMS using different Data Definition and Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, 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.
• Ensured proper execution of every function by monitoring QA production and staging environments.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Created interface stored procedures used in SSIS to load/transform data to PRMS
• Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
• Created OLAP Cubes and was responsible for OLAP processing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube
• Performed partitioning of cubes as well as cube optimization in order to increase the performance of cubes
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Created Parameterized reports and linked reports using Bookmark links and Hyperlinks.
• Created subscription for the windows file share and implemented three layer securities for the reports, SSRS website, and in the Intranet web application.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs
• Diagnosed and tuning the server optimal performance using SQL server 2005, Dynamic management views, Profiler and Index Tuning Wizards.

Environment: Microsoft SQL Server 2005 Enterprise Edition, T-SQL, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, MSvisio, Windows server 2003 and IIS 5.