SUMMARY

• About 8 Years of experience with Data Mining, Data Warehousing and Business Intelligence in Financial, Insurance, Retail, Telecom and Utilities domains
• Applications:
• Hands on experience in Erwin.
• Strong Knowledge on concepts of Data Modeling Star Schema/Snowflake modeling, FACT & Dimensions tables and Logical & Physical data modeling.
• Expertise in Microsoft Integration Services SSIS.
• Successfully extracted Data from Different Databases like Oracle, DB2, and Sybase.
• Expert in Migrating DTS Packages to SSIS.
• Extensive reporting experience using SSRS, Cogons and Crystal Reports.
• Well Experienced in generating parameterized, Slice and Dice, Drill down reports
• Excellent working noledge of Data Mining Models (Classification, Association Rule Mining, Clustering, Genetic Algorithms)
• Experience using Data Mining tools Microsoft Analysis Services.
• Skilled in Analysis Services OLAP cube and view development in SSAS.
• Vital Knowledge in OLAP Storage modes likes Rolap/Molap/Holap.
• Expertise in Writing MDX Query in OLAP Databases.
• Experience in Developing and working with Relational Databases (RDMS) like Oracle 11g/10g/9i/8i/8.x/7.x, DB2, MS SQL Server 7.0 2000/2005/2008 , MS Access 7.0/2000, TSQL, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000.
• Experience in Installing, Configuring, Managing, monitoring and troubleshooting of SQL Server 2012/2008/2005/2000 .
• Experience in Upgrade and Maintenance Patch management using SQL Server Tools like Database Maintenance Plan Wizard, DTS Import/Export Wizard, Index Tuning Wizard, Replication Sync Manager (Replication Wizard), SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer.
• Experience in Software Development Life cycle and developed Information Systems.
• Proficient in using Profilers for both performance and auditing purposes.
• Expertise in Resolve database performance issues, database capacity issues, replication, and other distributed data issues.
• Expert in creating indexed Views, complex Stored Procedures, TEMPeffective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Experience in Database Mirroring, Optimizing and Tuning of SQL Queries.
• Experience with SQL Server and T - SQL in constructing triggers, tables, user functions, views, indexes, Stored Procedures user profiles, relational database models, cursors, data dictionaries, and data integrity.

TECHNICAL SKILLS

Database Tools: SQL Enterprise Manager, SQL Profiler, Query Analyzer, Security Manager, Service Manager, SQL Server Analysis Services (SSAS).

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Import Export Data, Bulk Insert, BCP.

Data Modeling Tools: ERWIN 7.3, Power Designer 12.5, ER Studio 8.0.1, MS Visio 6.0.

Programming Language: T-SQL, PL/SQL, C, C++, C#, Assembly, HTML, Java Script, XML, .NET 2.0, Visual Basic 6.0, Visual FoxPro 5.0.

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports 9/10

Databases: SQL Server 2012/2008/2005/2000 , Oracle 8i /9i/10g/11g, MS Access

Operating Systems: Windows 9x/NT/XP/Vista, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, AL

Sr. SQL BI Developer

Responsibilities:

• Created SSIS packages to extract data from relational database and DB2 Mainframes, XML, Flat Files then transform and load into the data mart.
• Created store procedures, views, and tables and generated TSQL script for application.
• Write Complex Queries, stored procedures, Batch Scripts, Triggers, indexes and Functions using T-SQL for SQL Server 2008R2/2012.
• Fix any bugs arising out of SIT, UAT and any other test process.
• Involved in code review, writing Unit test case, creating a platform to run and validate the Test cases.
• Master deployment tools. Utilize team tools for change management. Advocate for architecture and design concepts dat can enhance performance and reduce maintenance costs.
• Mentor or act as subject matter expert in assigned technologies (e.g.: Octopus, Azure, etc.).
• Run the test cases written for integration and functional testing after the deployment of the databases.
• Used Visual Team Foundation server for version control, source control and reporting.
• Co-ordinate with other Teams and integrate different applications on to common platform.
• Responsible for report generation using SQL Server Reporting Services (SSRS).
• Worked in support to reporting and data needs noing the complex data responsibilities.
• Received reporting and data requests and then clarified the outcome with business partners, and developed reporting meeting their business needs.
• Worked with necessary parties to source and acquire data to meet critical business deadlines.
• Create SSRS reports according to user requirements and technical standards
• Customize output formats from SSRS to Excel, PDF, and CSV.
• Creating Report-Models for ad-hoc reporting and analysis.
• Developed Query for generating drill down reports using SSRS
• Designed and implemented stylish report layouts.
• Creating dashboards consisting of grids, charts and reports.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client’s workstation.
• Improved Report Performance and performed unit testing.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Developed reports with the new concept of Tablix Data Regions in the Report Layout, Created a stack of stepped reports using the Tablix
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS) to generate all daily, weekly, monthly and quarterly Reports including current status.
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.

Environment: Microsoft SQL Server 2012, Microsoft SQL Server 2008 R2, Visual Studio Team Foundation, Visual Studio 2010, T-SQL, SSRS, SSIS, BIDS, MS Word, MS Excel, MS Access.

Confidential, Chapel Hill, NC

Sr. SQL Server Developer (SSRS/SSIS)

Responsibilities:

• Responsible for SQL Server Reporting Services Planning, Architecture, Training, Support and Administration in Development, Test and Production Environments.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, 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.
• Created SSIS packages to clean and load data to data warehouse.
• Unit test code and participate in peer code reviews for other team members' work
• Review requirements and offer input before building the reports
• Developed T-SQL, User-defined functions, Joins and stored procedures with multi-valued parameters for generating complex reports.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Participated in creating Jobs for various packages dat run Confidential specific schedule every day based on some dependencies.
• Perform unit level analysis on all work done before handing over to the testing team
• Create SSRS reports according to user requirements and technical standards
• Customize output formats from SSRS to Excel, PDF, and CSV.
• Creating Report-Models for ad-hoc reporting and analysis.
• Developed Query for generating drill down reports in SSRS 2008 R2.
• Designed and implemented stylish report layouts.
• Creating dashboards consisting of grids, charts and reports.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2008.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client’s workstation.
• Improved Report Performance and performed unit testing.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.

Environment: MS SQL Server 2008 SSIS, SSAS, SSRS, T-SQL, SQL Profiler, Oracle 10g, T-SQL, SQL, PL/SQL, IIS, Windows

Confidential, Louisville, KY

Sr. SQL Server Developer (SSRS/SSIS/SSAS)

Responsibilities:

• Data Warehouse application development, support and maintain activities using Microsoft SQL server, SSIS, PL/SQL, Oracle database technologies.
• Working with the functional analyst and users to understand needs and develop new functionalities and tools. Modeling, designing, developing, tuning, and testing the back end structures to meet all requirements.
• Front end analysis prior to development or execution, as well as several phases of system testing.
• 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 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.
• Analyze, program and test data warehouse code owned by applications team using Oracle 11g, SQL server and .NET Technologies.
• Support the existing data warehouse platform and application, maintaining its availability and scalability.
• Designed Star Schemas and Snow Flake Schema for developing Cubes using MDX
• Hot fix for SQL Server Patch.
• Created tabular, matrix, chart, drilldown reports, parametric, cascaded reports and dashboards and scorecards reports according to business requirement in SSRS.
• Migrated data from Oracle to SQL Server data warehouse and to generate the reports using SSRS for different SSAS Cubes. Created several MDX queries according to business requirements. Used Performance Point Server 2007(PPS) application.
• Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using SSRS by SSMS.
• Responsible for report generation using SQL Server Reporting Services (SSRS) and Crystal Reports based on business requirements.
• Build ad-hoc reports using SQL Server Reporting Services (SSRS), Excel.
• Improved Report Performance and performed unit testing.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.

Environment: Microsoft SQL Server 2008, T-SQL, SSIS, SSRTS, SSAS, SQL, T-SQL, Oracle 10g / 11g, PL/SQL, .NET

Confidential, Alpharetta, GA

Sr. SQL Server Developer (SSRS/SSIS/SSAS)

Responsibilities:

• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Architecture, data modeling using Erwin; Data Warehousing and analysis skills: ETL tools, MDX, OLAP (MOLAP, HOLAP, and ROLAP), dimensional modeling, star schema and snowflake schema.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created SSIS packages for File Transfer from one location to the other using FTP task and Designed SSIS packages to extract data from flat files and oracle database.
• Integration Services (SSIS) -- Data sources and package connections. Control flow objects and data flow adapters. Debugging, deploying, and configuring SSIS packages. Securing and executing packages. Securing SSAS cubes. Querying cubes.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Used shell scripts and PERL scripts for automating the processes.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Business Intelligence Development Studio (BIDS) -- Using BIDS to create, edit, and deploy SSRS, SSAS, AND SSIS projects. Developed deployed and monitored SSIS packages including upgrades DTS to SSIS.
• Developed SSAS Cubes, Dimensions, Facts and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Analysis Services (SSAS) -- Creating data sources and data source views (DSVs), named calculations and named queries. Creating cubes, dimensions, measures, measure groups, key performance indicators (KPIs), perspectives, measure group partitions, partition aggregations, data mining models. Deploying and processing SSAS objects.
• Used Performance Point Server 2007(PPS) application.
• 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).
• Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using SSRS by SSMS.
• Build ad-hoc reports using SQL Server Reporting Services (SSRS)

Environment: SQL Server 2008, ORACLE 10g, SSRS, SSIS, SSAS, C#, VB.NET, ASP.NET, Visual Basic, MTS, Excel, MS Access, Visio, ERWIN.

Confidential, Chicago, IL

MS SQL Server SSRS/SSIS/SSAS Developer

Responsibilities:

• Participated in creating Jobs for various packages dat run Confidential specific schedule every day based on some dependencies.
• Migrated 80+ DTS packages using DTS editor wizard into SSMS Legacy folder, validated and tested all packages on development server.
• Recreated SQL Server 2000 DTS packages to MS SQL Server 2008 SSIS environment.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, 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.
• Created SSIS packages to clean and load data to data warehouse.
• Designed SSIS package for automatic data migration to transform Data from SQL Server 2000 to SQL server 2008.
• Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Wrote MDX queries and expressions for use in Front End BI Applications.
• Created KPI Objects in line with Requirement Docs.
• Optimized cubes for better query performance.
• Aggregated cube with 40% performance for better performance.
• Processed cube to perform incremental updates.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008/2005 (SSAS)
• Converted 60+ Cognos 6.0 reports to SSRS and deployed to production server
• Converted 20+ Cognos Powerplay reports to SSRS reports.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS) to generate all daily, weekly, monthly and quarterly Reports including current status.
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages, and PDA as well as window messengers.

Environment: MS SQL Server 2008 R2, SSIS, SSAS, SSRS, T-SQL, SQL Profiler, OLAP, OLTP, Erwin, BI xPress, Office-2007, MS Excel, SyBase ASE 15/12.5, AS400, Cognos 6.0/ 7.0, IIS 6.0

Confidential

MS SQL Server BI Developer/DBA

Responsibilities:

• Involved in planning & design.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Wrote Transact SQL utilities to generate table insert and update statements.
• Used SQL Profiler and Query Analyzer to optimize SSIS package queries and stored procedures.
• Migrated DTS packages to SSIS Packages
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Wrote T-SQL procedures to generate DML scripts dat modified database objects dynamically based on user inputs.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Involved in performance tuning (DB Tuning) using indexing (Cluster Index, Non Cluster index) tables.
• SQL Server used for database and ADO used for database interaction

Environment: SQL Server 2000/2005, DTS/SSIS, HTML, Java Script, VB Script.