SUMMARY

• 7 years of IT experience with a strong background in Data warehousing projects design, development and implementation with SQL Server 2008/2005/2000 in a high transaction and multi - server production environment. Self- learning ability and Leadership Quality.
• Well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.
• Expert in Extraction, Transforming and Loading (ETL) data using SSIS/DTS; creating mappings/workflows to extract data from SQL Server, Excel file, other databases and Flat File sources and load into various Business Entities.
• Expert in creating T-SQL objects, working with DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches.
• Experience in writing Distributed Queries between SQL Servers.
• Handled huge financial data, expert level query optimization and performance tuning experience
• Experience in creating Jobs, Alerts, setting up SQL server mail agent for SSIS packages.
• Proficiency in Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects.
• Expertise skill in Migrating/Re-writing DTS packages to SSIS packages using Upgrade Advisor/Package Migration Wizard.
• Expertise in generating reports using Crystal Reports, SQL Server Reporting Services, and Microsoft Access & Excel spreadsheet.
• Experience in creating various reports like drill down, sub reports, parameterized, multi-valued reports through Report model creation.
• Experience in Design and optimization of OLTP, OLAP tools, creating SSAS based OLAP Cubes.
• Instructed and modeled core Agile principles of collaboration, prioritization, team accountability and visibility; ensured consistent application of scrum methodologies across the enterprise
• Strong analytical skills with broad range of computer expertise.
• An excellent problem solver, able to identify opportunities for improvements and resolution of critical issues.
• An effective leader, skilled in enlisting the support of all team members in aligning with project and organizational goals.

TECHNICAL SKILLS

Languages: C,C++, SQL, T-SQL SQL Server Tools & Packages SQL ServerManagement Studio, Enterprise Manager, Business Intelligent Studio, Configuration Manager, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard, SQL ServerAgent.

Reporting Tools: SSRS, Crystal Reports

ETL Tools: SQL ServerIntegration Services (SSIS), SQL ServerDTS.

Databases: SQL Server 2000/2005/2008/2008 R2, MSAccess 97/2003/2005/2008, Oracle 11g/9i, DB2

Data Modeling Methodologies: Kimball Star Schema, Snowflake schema.

Data Warehousing & BI: SQL Server, Business Intelligence Studio, SSIS, SSAS, SQL Server 2008/2012 Analysis Services and SQL Reporting services, DTS

Web Technologies: HTML, DHTML, XML, Visual Studio, MSFront page.

Operating Systems: Windows Server 2000/2003/2008/2008 R2, Windows NT & XP.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

SQL/SSIS/SSRS Developer

Responsibilities:

• Planned, defined and designed data based on business requirement and provided documentation for all kinds of reports, DTS and SSIS packages for further reference.
• Developed SSIS Packages using Look Up Values & implementing rules provided by business in the mapping document.
• Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Generated parameterized reports, sub reports, Drill down reports, Drill through reports using SSRS 2008 and 2008 R2.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS 2008 R2.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Fine-tuned SQL Queries for maximum efficiency and performance.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Worked in setup logging environment to track the status of the events like error raise, task fail.
• 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, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.
• Created reports which 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 Confidential various levels using Report Manager
• Fine tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.

Environment: MS SQL Server 2008 R2, SSRS, T-SQL, SSIS, Win 2003 Advanced Server and ERwin v7.2

Confidential, Plano, TX

SSIS/SSRS/SSAS 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.
• 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.
• Involved in loading data from various file formats (Flat file, Excel) using Oracle loader and SQL* Loader.
• 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.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent in SSAS.
• Gained 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 and Aggregated cubes with 40% 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.
• Worked on deploying and scheduling Reports using SSRS as well as triggers 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.
• Used Index Tuning Wizard, SQL Profiler and SQL Query analyzer for Performance Tuning.

Environment: MS SQL Server 2008 R2, SQL Server Reporting Services 2008 R2, SQL Server Integration Services 2008 R2, SQL Server Analysis Services 2008 R2, MS Visio 2007, Windows 7/ Vista and T-SQL

Confidential, Dublin, OH

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Created and modified stored procedures, triggers, views, partition function and schema for table partitioning.
• Designed packages for Extracting, Transforming and Loading (ETL) data from Excel, Flat file and any OLE DB data source to MS SQL Server by using BCP utility and SSIS services.
• Worked on SSIS for transferring data from Heterogeneous Data format to SQL Server.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, FTP Task, Package Execution task to achieve business needs.
• Monitored and Optimized SSIS package performance to reach the expected timeframe for data loading.
• Used various transformations like Lookup, Aggregate, Sort, Multicasting, Conditional Split, Derived Column, Slowly Changing Dimension for performing different functionalities of the packages.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports using SSRS 2008.
• Created tabular, matrix, chart, parametric, cascaded reports and dashboards and scorecards reports according to business requirement.
• Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.

Environment: MS SQL Server 2008 R2, SSRS, T-SQL, SSIS.

Confidential, Glen Allen, VA

MS SQL Developer/SSIS/SSRS/SSAS Developer

Responsibilities:

• Planned, Defined and Designed database based on business requirement and provided documentation.
• Coordinated with DBA in creating and managing tables, indexes, triggers, database links and privileges.
• Gathered data and documented it for further reference and designed Database using Erwin data modeler.
• Created SSIS package to load data from Flat Files and SQL Server 2005 to SQL Server 2008 using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• 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 using SQL Server Agent.
• Responsible for creating cubes and dimensions using MS SQL Server Analysis Services (SSAS).
• Created business critical KPIs using MS SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

Environment: SQL Server 2008, BIDS, SSRS, SSIS, SSAS, Crystal Reports

Confidential

MS SQL Server Developer

Responsibilities:

• Analyzedbusiness requirementsandbuild logical data modelsthat describe all the data and relationships between the data.
• Created new database objects likeProcedures, Functions, Packages, Triggers, IndexesandViewsusingT-SQLinSQL Server 2000.
• Responsible for development of standard reports UsingCrystalReportsfor the Vendor Sell buyback database and was the key report developer and Product support for the project
• Validatedchangerequestsand made appropriate recommendations.Standardizedthe implementation of data.
• Promoteddatabase objects from test/developto production. Coordinated and communicated production schedules within development team.
• Modified database structuresas directed by developersfortest/developenvironments and assist withcoding,designandperformance tuning.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created theDTSPackagethroughETLProcessto vendors in which records were extracts fromFlat fileandExcelsources and loaded daily Confidential the server.
• Assistedwith variousad hoc query requests.
• Providedback-endsupport forfunctional testingandperformance testing.

Environment: SQL Server 2000,T-SQL, DTS Designer, MS-Office, Ms-Excel.