SUMMARY

• Over 6 years of experience in IT industry as a SQL Developer/ BI Developer all software development phases from requirements definition, analysis to design, implementation, testing, maintenance.
• Excellent knowledge in Dimensional Modeling, ER Modeling, Data Marts, Star Schema/Snowflake Schema, FACT and Dimensional tables.
• Extensive experience in using all types of SQL Server Constraints, SQL Server Database design, Database maintenance, developing Transact - SQL queries, stored procedures, and triggers using SQL.
• Expert in creating indexes, Stored Procedures, user defined functions, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
• Extensive experience in Oracle, MS SQL Server 2005/2008/2012 , Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services, and MS SQL Server Analysis Services
• Experienced in designing the Conceptual, Logical and Physical data modeling using ERwin and ER Studio Data modeling tools.
• Good in system analysis, ER Dimensional Modeling, Database design and implementing RDBMS specific features.
• Experience in modeling with both OLTP/OLAP systems and Kimball and Inmon Data Warehousing environments.
• Created SSIS Packages using Various Transformation like Lookup, Derived Columns, Condition Split, Data Conversion, Aggregate, Merge Join, Sort, 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.
• Efficient in generating Tabular, parameterized reports, drill down, drill through, cascading parameterized, and matrix reports using SSRS 2012/2008R2/2005.
• Having good experience with Normalization (1NF, 2NF and 3NF) and Denormalization techniques for improved database performance in OLTP, OLAP, Data Warehouse and Data Mart environments.
• Experienced in designing the data mart and creation of cubes.
• Experienced in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities. Also, experienced in Optimizing MS SQL Query using tools like SQL Server Profiler, Database engine tuning advisor, and Dynamic management views.
• Efficient in analyzing and documenting business and functional requirements along with Use Case Modeling and UML.
• Expert in developing SSIS packages to Extract, Transform, and Load data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access as well as processing and archiving various format source files.
• A good expertise in Extract Transform and Load (ETL) data from spreadsheets, database tables and other sources using Informatica
• Experience in data transformation, data mapping from source to target database schemas, data cleansing procedures.
• Expert in creating MOLAP Cubes using SSAS with Roles and Security Administration
• Highly experienced in optimizing OLAP Cubes by partitioning them, Designing Aggregations, implementing Hierarchies and Calculated Members
• An excellent experience in generating ad-hoc repots using Crystal Reports 9 as well as SSRS cube-linked reports.
• Experience in the work environment consisting of Business analysts, Production/Support teams, Subject Matter Experts, Database Administrators and Database developers.
• Excellent problem solving and analytical skills with exceptional ability to learn and master new technologies efficiently

TECHNICAL SKILLS

• SQL Server
• SQL Integration Services
• SQL Reporting Services
• SQL Server Analysis Services
• VB
• ASP
• C#
• Erwin Designer
• Crystal Reports
• SQL Profiler/Analyzer
• Bulk Copy Program (BCP),
• Database Engine Tuning Advisor
• SQL Agent
• Service Manager
• Windows
• MS Office

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

Business Analyst/OLAP Technical Lead/ SSIS/T-SQL Developer

Responsibilities:

• Installed all required software, requested necessary access permissions, and provided to unfamiliar and new technologies to newly on-boarded developers.
• Interacted and collaborated with 3 business groups on a daily basis to capture, document, merge, and implement their distinct operational logic under one universal platform.
• Provided extensive project documentation based on gathered requirements.
• Created and unified over 30 ETL mappings from staging to integration layer and from integration to the reporting layer.
• Modeled staging layer and fact tables using Erwin 7.3.
• Migrated and integrated historical data from Oracle and SAP BW sources with live EDW data.
• Modeled the fact tables and developed packages to populate them with T-SQL tasks to aggregate product warranties and their over time amortization.
• Developed update strategy to reflect additional warranties that applied to products based on ship to regions and other client purchased warranty extensions.
• Conducted weekly gap analyses to match to-be-retired systems with newly developed platform
• Provided out of the box solutions to complex data quality issues, such as synthetic product serialization.
• Worked with Job scheduling team, provided and identified dependencies as well as job running schedules.
• Created global temporary log tables to monitor jobs performance and fine tuned jobs run time.
• Developed complex T-SQL queries to load data including loops with nested cursors and merges.
• Managed and lead a team of 5 people from Shanghai and India during OLAP cube development.
• Integrated enterprise golden (conformed) dimension with Business Managed Tables to reflect all applicable reporting requirement.
• Managed OLAP Cube’s Security by Roles and Perspectives.
• Created dynamic cube Partitions which reprocessed data on daily and monthly schedules.
• Created several drill through reports linked with SSRS reports.
• Developed Data Quality reports based on discovered data anomalies.
• Constructed multiple calculated members using MDX statements.

Environment: SQL Server 2005/2008, SSIS, SSAS, SSRS, Toad 5.3, Oracle 10g, Subversion, Share Point, Microsoft Visio, Erwin 7.3, Visual Studio 2008, Excel 2013, Tidal Scheduler

Confidential, Atlanta, GA

SQL Server BI Developer

Responsibilities:

• Planned, defined and designed data based on the business requirement.
• Developed database objects such as Stored Procedures, Functions, Tables, Triggers and Indexes using T-SQL and SQL Analyzer.
• Created complex reports which includes cascade parameters, multivalve parameters and conditional formatting to generate user friendly reports.
• Created reports using Reporting Services to retrieve data using database code objects such as stored procedures, views and multiple T-SQL queries.
• Developed packages in SSIS for aggregating data files and database sales information and consolidating for reporting & cubes.
• Used multiple transformations in SSIS such as Conditional Split, Bulk Insert, Merge and Data Conversion.
• Designing Cubes, Star Schema and Data models for Data Warehousing Applications
• Developing Reporting in SSRS Report Viewer Control and integrating to Web application as client side reporting.
• Created Report Services Models for different business channels to implement Ad-hoc reporting.
• Documented all the reports such as technical specifications which include test cases, parameters involved and report running time and so on.
• Migrated data from various sources into SQL Server using SQL Server Integration Services
• Developed different types of Tabular Reports, Matrix Reports (Cross Tab or Pivot), Chart and Graphs, Reports that aggregate data, Reports containing parameters and group, Reports containing Totals and Subtotals, Drill-down reports and ad-hoc reports using SQL Server Reporting Services.
• Designed dynamic DTS and SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Created packages using DTS and SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server using ETL Tool.
• Performance Tuning the Stored Procedures used in SSIS Packages and SSRS Reports.
• Designed and developed reports using SQL Server Reporting Services
• MDX Coding and MDX object modeling using analysis services
• Developed Stored Procedures and Views used to supply the Data to the Reports.
• Configured, built, deployed different reports in PDF, Excel, TFI formats according to the business requirement using SQL Server Reporting Services.
• Developed reports where the data extracted from SSAS cubes in SSRS.
• Designing OLAP cubes, Data Modeling, Dashboard Reports according to the business requirement for the sales department.

Environment: SQL Server, Management Studio, SQL, PL/SQL, ETL, DTS, Integration Services, Reporting Services (SSRS), Analysis Services (SSAS), Integration Services (SSIS), Data Modeling, T-SQL, SQL Profiler, Windows

Confidential, Chicago, IL

SQL Server BI Developer

Responsibilities:

• Worked closely with Business Analysts to produce all required documentation.
• Created various Database Objects - Tables, Indexes, Views, and Roles.
• Used SSRS to create various ad-hoc, parameterized, drill-down and drill-through reports weekly and monthly showing detailed information of the Vendors information, Titles Information.
• Developed complex stored procedures and triggers in T-SQL.
• Created SSIS process design architecting the flow of data from various sources to target.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Built and Deployed reports on the server using SSRS Report Manager.
• Installed and configured SQL Server 2005 successfully on Windows Server
• Fine tuned database objects and server to ensure efficient data retrieval.
• Assisted the front end application developers with their queries.
• Transferring the data from SQL server 2000 to SQL Server 2005 using SSIS.
• Wrote and integrated Stored Procedures to generate the Reports.
• Created various Tabular, Cross-tab, Matrix and Ad-hoc reports using SSRS.
• Created Stored Procedures, T-SQL, Triggers, Views and Functions for the database Application.
• Extensive testing on the Performance of the Stored Procedures using SQL Profiler and Query Analyzer.
• Extensively used Report Wizard, Report Builder and Report Manager in SSRS.

Environment: SQL Server, ETL Tools, DTS, T-SQL, SQL Profiler, Visual Source Safe, SQL Reporting Services (SSRS), Analysis Services (SSAS), Integration Services (SSIS).

Confidential, Livonia, MI

SQL Server BI Developer

Responsibilities:

• Gathered user requirements, analyzed and designed of software and database solutions.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports as well as interactive reports according to business requirements in time restricted environment.
• Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server
• Wrote SQL scripts to Insert, Update and Delete data in SQL database.
• Dropped and recreated the Indexes on tables for performance improvements
• Created schemas, views, stored procedures, Triggers and functions for Data Migration.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer and SQL Enterprise Manager.
• Designed a report on the monitoring of Server Performance using Task Manager. This report gives a detail report to the management on the Performance of the server.
• Created database, tables and procedures to update and clean the old data.
• Worked with the front end application developers with their queries.
• Created SSIS Packages to import and export data from Excel, XML and Text files.
• Documented all the reports such as technical specifications which include test cases, parameters involved and report running time and so on.
• Designed, developed and deployed reports, Drill down reports, Drill through reports and Parameterized reports in MS SQL Server environment using SSRS and also configured the Cache execution, report execution time out and scheduled Snapshot reports to increase performance.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Suggested creating Clustered and Non-Clustered indexes on tables.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Involved in project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.

Environment: SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS Access, SQL Analysis Services, MS Excel, Visual Studio 2005, Windows Server 2003, Toad, ERWIN

Confidential, Lincoln RI

SQL Server Report Developer

Responsibilities:

• Designed and developed ER diagrams (Physical and Logical using MS Visio) and mapping the data into database objects.
• Scheduled the reports to run on a daily and weekly basis in Report Manager and then provided them to the analysts to review in Excel Spread Sheet
• Expertise in developing advanced reports with functions, formulae, parameterized reports, sub reports, summary reports, cross tabs, ranking and conditional formatting.
• Created, insert, update and delete triggers on some tables in order to capture any DML activities happening on some crucial and confidential data.
• Implemented indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval.
• Involved in creating various scripts to load the data to and from production servers to the development servers.
• Designed and developed different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, Drill down reports.
• Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Created stored procedures, views, triggers, user defined functions to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Formatted the reports using the Global variables and expressions.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

Environment: SQL Server, SQL Server Reporting Services, SQL Profiler, Query Analyzer, MS Office

Confidential, Huston TX

SQL Server Report Developer

Responsibilities:

• Worked with the business analyst in translating business needs and requirements into functional design specifications.
• Designed and normalized the databases and created different objects like tables, views, Stored Procedures, UDFs, indexes rules and defaults on MS SQL Server.
• Generated reports using Global variable, Expressions and Functions using SSRS.
• Responsible for designing, creating and deploying the reports into the production server
• Created, insert, update and delete triggers on some tables in order to capture any DML activities happening on some crucial and confidential data.
• Scheduled the reports to run on a daily and weekly basis in Report Manager and then provided them to the analysts to review in Excel Spread Sheet
• Implemented indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval.
• Involved in creating various scripts to load the data to and from production servers to the development servers.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server
• Created Drill Down, Drill through, linked and sub reports using SSRS. Built Reports in SSRS for errors generated in SSIS Packages.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Involved in the development of custom stored procedures, functions, triggers, SQL, T-SQL.
• Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.

Environment: SQL Server, T-SQL, Windows, Visual Studio, SQL Profiler, Erwin, SSRS, Visio, Share-Point.