Summary:

• Over 7 years of professional experiences in MS SQL Server 2005/2008/2012 design, development and testing, and deeply understood business objectives and processes in Financial Insurance and Manufacture Industry fields.
• Strong experiences in software development life cycle SDLC , Prototype and supported production environment in business.
• Strong experiences in Data Architecture and designing Enterprise Data Warehousing, Data Marts, Dimensional Database Fact tables Dimensional tables .
• Strong SQL Server Developer experiences to develop tables, views, indexes, triggers, stored procedures, CTEs and joins by using T-SQL. Strongly expertise to check logical and physical consistency of database by using Database Consistency Checks Utilities DBCC .
• Strong experiences in Troubleshooting, debugging, specifying issues in database, and improving database performance by using Index strategy, stored procedures and tuning technology.
• Strong Expertise in MS SQL Server with Business Intelligence Development Studio BIDS 2005/2008/2012 in SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS and SQL Server Analysis Services SSAS .
• Strong experiences in migrating and transforming data by using ETL package in SSIS, Bulk Copy Program BCP , Bulk Insert, Data Transformation Services DTS , and synchronizing daily data.
• Strong experiences in handling change data capture CDC , slowly changing dimension SDC , early/late arriving facts and complex mappings in SSIS.
• Strong experiences in configuring and deploying SSIS package, creating types of jobs for SSIS Packages in SQL Server Agent on daily/weekly/monthly basis.
• Strong experiences in generating different types of Reports like Ad-hoc reports, Dashboard reports, Linked reports, Sub-reports, Parameterized reports, Drill-down and Drill-through reports by using T-SQL and SSRS.
• Integrated Report Services directly with XML data sources and Web services
• Strong experiences in deploying reports on web-portal by using SSRS, Report Builder and MS SharePoint.
• Strong experiences in using MS Power View and MS Power Pivot for customizing report.
• Strong experiences in Data Marts, Data Warehousing, Operational Data Store ODS , Calculation Scripts, Data Matrix, Star/Snowflake Schema Modeling, Partitions.
• Strong expertise in Data Warehousing Architecture Approach Bill Inmon Ralph Kimball , developing OLAP cubes ROLAP/MOLAP/HOLAP and exporting cubes to Pivot Tables by using SSAS and MS Excel.
• Strong experience in setting up KPI, calculations, and hierarchy.
• Strong experiences in MS Team Foundation Server for organizing process of project.
• Strong Object Oriented Analysis, designing and programming technical skills, ability to learn and adapt new emerging technologies quickly.
• Ability to handle multiple tasks and demonstrates initiative and adaptability and capable of handling responsibilities independently as well as a proactive team member.

Skill Set:

Data Architecture, SDLC, DTS, T-SQL, MDX, HTML, CSS, XML, Microsoft SQL Server 2005/2008/2012, SQL Server Analysis Services 2005/2008/2012, SQL Server Integrated Service 2005/2008/2012, SQL Server Reporting Services 2005/2008/2012, Report Builder, Power Pivot, Power View, Visual Studio, Performance Monitor, SQL Profiler, Database Engine Tuning Advisor, MS SharePoint, MS Team Foundation Server, MS Visio, MS Access, MS Excel, MS Office, Crystal Reports, MS Windows OS, MAC OS.

Project Summary:

Confidential

MS SQL BI Developer SSIS, SSRS

Responsibilities:

• Implemented projects followed by Agile Scrum Methodology.
• Gathered business requirements to map new data source/schema for preparing enterprise data warehouse architecture on the logic development.
• Assisted application developers to manipulate data by writing complex T-SQL commands including: Queries, Joins, views, triggers and stored procedures.
• Tuned and optimized database and queries to improve queries, ETL packages and reports' execution.
• Designed and built up high performance ETL packages to migrate and manipulate data from Access, Oracle, MS Excel, Flat Files and SQL Server by using SSIS.
• Incrementally and dynamically loaded data by using SSIS. Converted cursors to ETL packages to replace command shell.
• Debugged and troubleshoot the existing ETL packages. Deployed, monitored, scheduled and executed SSIS packages by using MS BIDS and SQL Server Agent.
• Conducted and monitored jobs and databases by using SQL Server Agent, SQL Profiler and Database Engine Tuning.
• Backed up, restored and copied databases among different servers.
• Assisted team to sign the database permission for co-worker. Set alerts to database administrator and project manager. Implemented disaster recovery including: log shipping and replication.
• Debugged exiting reports and fixed the issue by using SSRS and Report Builder.
• Designed dashboard reports including dashboard reports, drill-down reports, drill-through reports, cascading reports to support other departments.
• Prepared documentation for projects.

Environment: MS SQL Server 2008 R2/2012, SQL Server Integration Services SSIS 2008 R2/2012, SQL Server Reporting Services SSRS 2008 R2/2012, VB.NET, HTML, XML, SharePoint, Oracle, MS Access, SQL Server Agent, SQL Profiler, Database Engine Tuning Advisor.

Confidential

BI/ SQL Developer SSIS, SSAS, SSRS

Responsibilities:

• Gathered business requirements and worked in conjunction with the enterprise data warehouse architecture on the development of logical data models.
• Installed and Configured SQL server 2008 R2/2012 on Development and production server.
• Using complex T-SQL SQL Queries, Joins, UDF, Trigger, Stored Procedure, Index to manipulate data, secure and optimize database.
• Developed partition dimension tables and execute as parallel approach.
• Conducted and monitored database management by using SQL Profiler, Database Engine Tuning Advisor and Index Tuning Wizard.
• Built up high performance ETL package, migrated data from Oracle, Flat Files and MS Excel, cleaned and backed up data, and synchronized daily transactions by using SSIS.
• Incrementally and dynamically loaded and transformed data by using SSIS like, Change Data Capture, Slowly Changing Dimension .
• Developed, monitored, scheduled and executed SSIS package by using MS BIDS and SQL Server Agent.
• Generated reports from different Databases and OLAP data warehousing.
• Executed daily report and list reports by using Pivot Command, Stored Procedures and Crystal Report.
• Developed Parameterized reports, Drill-through reports, Drill-down reports, Matrix reports, Charts like, Gantt Chart based on Business requirements by using SSRS.
• Developed Ad-hoc reports and modified them by using SSRS and MS Report Builder. Created Cache reports and Snapshot reports for retrieving stored reports.
• Deployed types of reports into web-portal by using SSRS and XML.
• Developed Dashboard reports and implement them to MS SharePoint. Used MS Power View and MS Power Pivot to develop Dashboard reports.
• Configured out IIS, deployed and scheduled reports by using SSRS and Report server.
• Followed Ralph Kimball Approach and created multi-dimensional data warehousing including snowflake schema, data marts, fact tables and dimension tables.
• Designed OLAP cubes and SSAS solutions Perspective, Partition, Aggregations, Calculations, KPI by using SSAS and MDX, and exported to Pivot table in MS Excel for analyzing performance of strategic business units.
• Used MS Team Foundation Server TFS 2010 to organize the process of project. Strong ability to handle multi tasks in project.

Environment: MS SQL Server 2008 R2/2012, SQL Server Integration Services SSIS 2008 R2/2012, SQL Server Analysis Services SSAS 2008 R2/2012, SQL Server Reporting Services SSRS 2008 R2/2012, HTML, XML, IIS, MDX, MS TFS, SharePoint, Oracle SQL, Crystal Report, SQL Server Agent, SQL Profiler, Database Engine Tuning Advisor, Index Tuning wizard.

Confidential

BI/ SQL Developer SSIS, SSAS, SSRS

Responsibilities:

• Created data mapping document to provide source and destination mappings for effective Enterprise Data warehouse. Involved in implementing logical and Physical Database modeling.
• Created dynamical queries, indexes, stored procedures, views, joins and User defined functions, trigger and implemented as per the business requirements for secured data storage, efficient data manipulation and troubleshooting.
• Designed and deployed various ETL packages to migrate the data coming from flat file, Excel, XML and SQL Server and to synchronize daily transaction data.
• Generated different types of reports from SQL Server and OLAP Enterprise Data Warehousing, and daily list reports by using stored procedures and Crystal Report.
• Developed and deployed Tabular Reports, Matrix Reports, Drill-Down reports, Cross-Tab Reports and Ad hoc reports by using SQL Server reporting services SSRS .
• Maintained and modified reports by using XML for updated web data service and using Report Builder for Ad-hoc reports. Implement Dash reports to MS SharePoint for different departments.
• Scheduled and subscribed reports by using Report Server.
• Designed, implemented data mart, facts, dimensions and online analytical processing OLAP cubes using dimensional modeling standards, and created cubes by using SSAS.
• Set up security and perspective for OLAP cube by using SSAS.
• Deployed the cubes and verified the result on the browser. Exported cubes to Pivot Tables in Excel for business analysis.
• Planed and implement strategies of project that would ensure all the business requirements reflect in the project development. Organized project process by using MS Team Foundation Server.

Environment: MS SQL Server 2008/2008 R2, SQL Server Management Studio SSMS , MS SQL Server Integration Services SSIS 2008/2008 R2, MS SQL Server Analysis Services SSAS 2008/2008 R2, MS SQL Server reporting Services SSRS 2008/2008 R2, T-SQL, OLAP, XML, MS Visio, MS Excel, MS Office, Crystal Report, MS TFS.

Confidential

BI/ SQL Developer SSIS, SSAS, SSRS.

Responsibilities:

• Expert in preparing clinic document mapping and transforming complex business logic into Database design and maintaining it by creating T-SQL command in Stored Procedures, User Defined Functions, Views and T-SQL Scripting.
• Developed advanced correlated and un-correlated sub-queries in T-SQL to create complex reports and prepared the List Report for customers. Extensively used XML documents to pass multiple parameters for Stored Procedures to read and write database table.
• Extracted and migrated data from different data sources including flat files, Excel spread sheets, CSV files and DB2 by creating ETL packages.
• Developed and deployed Cross-Tab reports, Sub-Reports, Drill-down reports, Drill- through reports, Linked reports by using SSRS based on different business requirements.
• Applied graphs and images into reports. Scheduled daily/weekly/monthly reports for executives, business analysts and customer representatives in different categories and regions based on business needs by using SSRS.
• Created and deployed Star Schema data marts for OLAP Cube generation. Developed a multi-dimensional database, OLAP cube and Pivot Tables by using SSAS.

Environment: MS SQL Server 2008 Enterprise Edition, SQL Server Integration Services SSIS 2008, MS SQL Server Analysis Services SSAS 2008, SQL Server Reporting Services SSRS 2008, Visual Studio, T-SQL, XML.

Confidential

MS SQL Server Developer SSIS, SSAS, SSRS

Responsibilities:

• Prepared health document mapping and created logical and physical data models.
• Created database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups. Created Clustered and Non-Clustered indexes on tables.
• Created User Defined Functions, triggers, cursors, tables, and views and other SQL joins for applications. Fine-tuned complex SQL queries and Stored Procedures to improve performance.
• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, Instances, Linked Servers and Indexes.
• Created ETL package for data population from different sources like flat files and Excel files and for data conversions in SSIS.
• Developed and deployed daily table reports, matrix reports, sub reports based on business needs by using SSRS.
• Scheduled and subscribed reports, and sent alert by email.
• Created Star Schema data mart and developed a multi-dimensional database, cubes and Pivot Tables by using SSAS.

Environment: MS SQL Server 2005/2008, SQL Server Integration Services SSIS 2005/2008, SQL Server Analysis Services SSAS 2005/2008, SQL Server Reporting Services SSRS 2005/2008, T-SQL, SQL Profiler, Database Engine Tuning Advisor, BCP, Import Export Wizard, Report Wizard.

Confidential

MS SQL Server Developer/ Reports Developer

Responsibilities:

• Carried out a Developer's role on MS SQL Server 2005 and MS Access Databases.
• Logical and physical database development by using Normalization, Dimension Modeling and Enterprise Manager.
• Developed complex T-SQL command in creating tables, constraints, indexes and views.
• Designed and Implemented the Stored Procedures and Triggers for automating tasks.
• Used DTS for data population from different sources, created DTS packages for data conversions and loaded data from flat flies and excel files.
• Worked on MS SQL Server tasks such as Batch Jobs, BCP, views and indexes.
• Generated daily report list by using SQL queries and Stored Procedures.
• Created and automated regular Jobs such as Daily/Weekly Report Generations in Crystal Reports.

Environment: MS SQL Server 2005, MS Access, T-SQL, DTS, BCP, Crystal Reports.