SUMMARY

• 7+ years of experience in IT, Financial and Healthcare environments with primary skill on the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite.
• Excellent experience in SSIS, SSAS and SSRS of MS SQL Server.
• Highly expert in translating Business System Design document into technical design document
• Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.
• In - depth knowledge of T-SQL, Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2012/2008/2005/2000.
• Excellent knowledge of using variables and expressions in packages.
• Experience in scheduling SSIS packages using SQL Server Agent.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Excellent skills in implementing ETL Packages using DTS and SSIS 2012/2008/2005.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases.
• Extensive hands-on experience using Informatica Power Center 9x/8x to create and edit Transformation, Mapping, Task, Sessions and Workflow to extract data from various types of sources, transform according to predefined logic, and Load into Target database in required formats.
• Experience in Performance Tuning and Query Optimization.
• Well versed in Performance Point Server 2007. Designed Dashboards, Scorecards and reports using multiple KPI’s, OLAP charts and SSRS Reports with PPS.
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)
• Experience in creating packages to transfer data between Oracle, DB2, MS Access and Flat Files to SQL Server using DTS/SSIS.
• Expert in creating the MDX cubes and dimensions.(SSAS)
• Experience in logical, physical, and dimensional data modeling, data mapping, and data normalization, well verse in Erwin
• Experience with Data Mining, create Data Mining Structure by using Data Mining Model. Using DMX to create data mining queries.
• Experience in Data Warehouse MS PDW; Green Plum, Teradata.
• Expert in creating Parameterized Reports
• Hands on experience in Creating Star Schema and Snow Flake Schemas
• Experience in .Net, ASP.Net and C# to Create SSIS Package and Report.
• Experience with different Data Warehouse environment: Teradata, Green Plum, and PDW. Well using other BI tools, such as Business Objects, Business Objects Data Integrator, Crystal Report.
• Good understanding with of SDLC (System Development Life Cycle) and Project Management work flow and writing Data movement High Level Design and Low Level Design documents, using Microsoft Visio.
• Very methodical and well organized with excellent bottom-line for work
• A quick learner, punctual and trustworthy
• A capable and resourceful team member who also possesses excellent written and verbal communication skills

TECHNICAL SKILLS

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

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Informatica 9X/8X, Extract, Transfer and Load, 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, JAVA, C#, HTML, Java Script, XML, .NET 2.0, Visual Basic 6.0.

Web Tools: MS-Front Page, MS-Outlook Express.

Reporting Tools: Crystal Reports 9/10/11, SQL Server Reporting Services (SSRS), MS Access, Excel.

Databases: SQL Server 7.0 / 2000/ 2005/2008/2012, Oracle 8i /9i/10g/11g, MS Access, PDW, Teradata, Green Plum.Operating Systems: Windows 9x/Me/NT/XP/Vista/7, MS-DOS, UNIX, Linux.

PROFESSIONAL EXPERIENCE

SQL Server/BI Developer

Confidential, Jessup, PA

Responsibilities:

• Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications by using T-SQL.
• Managed the entire ETL process, involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers in sales area.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
• Wrote T-SQL procedures to generate DML, DDL scripts that modified database objects dynamically based on user inputs.
• Created SQL jobs, Maintenance plans and scheduled them as required.
• Performance tuning and optimization of procedures and queries. Involved in the tuning of the existing Database Objects.
• Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio and Database Engine Tuning Advisor.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008 from different environments for the SSAS cubes.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Involved in writing Visual C#, .Net/ASP.Net Scripts in SSIS Packages and Reports.
• Involved in deploying the SSIS packages into different environments like QA and Production.
• Helped in Designing Business Models as per requirement for SQL 2008 Analysis Services cubes.
• Extensively involved in designing the SSIS packages to load data into Data Warehouse. Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Adhoc reports through Report Builder Using SSRS 2008. Involved in gathering the business requirements for the SSRS Reports.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Creating Flat File, Excel, and PDF Report by using SSIS package, Power View, Power Pivot and Crystal Report.
• Published high-level technical documentation to set standards, guidelines and best practices for SQL Server Database Design, Coding Standards, Periodic Data refresh, database upgrades across the enterprise

Environment MS SQL Server 2008, SSIS, SSRS, SSAS, OLAP, OLTP, T-SQL, Green Plum, MySQL 5.1, Stored Procedures, SQL Server Enterprise Manager, ETL, DTS, Visual Studio 2010/2008, Share Point Server 2012, C#, .Net/ASP.Net, IIS 4.0, Facets 4.71/4.31 SQL Server Query Analyzer, SQL Profiler, Erwin4.1, Excel 2013/2010.

SQL Server/BI Developer

Confidential, Coraopolis, PA

Responsibilities:

• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Extensively involved in designing the SSIS packages to load data into Data WareHouse. Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Extract Transform Load (ETL) development using SQL Server 2012/2008, SQL 2008/2012 Integration Services (SSIS) and Business Objects Data Integrator.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling. Experience in moving the data from heterogeneous data sources like oracle, xml etc to SQL using SSIS.
• Hands on experience in using different transformations like fuzzy lookup, derived column transformation etc using SSIS.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, developing reports using MDX and SQL.
• Experience in logical, physical, and dimensional Data Mining, Data Modeling, Data Mapping, and Data Normalization.
• Experience in creating Partitions for the SSAS Cubes. Experience in working with SSAS Cubes having Fact less Fact Tables and Slowly Changing Dimensions.
• Experience in creating a Data Mining structure based on an OLAP cube, defining Data Mining Models, and slicing the source cube.
• Developed Informatica mappings for Salesforce data integration with logic, such as lookup, load validation and reprocess.
• Used Microsoft Word and Visio to write the data Pop/Sync (population and synchronization) Low Level Design and High Level Design Documents.
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Adhoc reports through Report Builder Using SSRS 2012/2008. Involved in gathering the business requirements for the SSRS Reports.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Experience in creating detailed installation and deployment instruction documentation.
• Responsible for delivering the project goals on time from technical perspective.
• Experience in different Database to retrieve or load data process, such as DB2, Oracle, MS SQL Server, and Access.
• Extensively managed On Shore and Off Shore Co-ordination.

Environment SQL Server 2012/2008, SQL Server BI Development Studio (BIDS) 2012/2008, SQL Server Integration Services (SSIS), Informatica 9.1, MS Visio 2007/2003, Share Point Server 2010/2007, Windows 7/Vista/NT/XP /2003/2000/98, Windows2000 Advanced Server, Oracle 11.g, DB2 9.7, Sales Force.

SQL Server/BI Developer

Confidential, Berkeley Heights, NJ

Responsibilities:

• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification, indexing and statistics updates.
• Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications by using T-SQL.
• Managed the entire ETL process, involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers in sales area.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Performance tuning and optimization of procedures and queries. Involved in the tuning of the existing Database Objects.
• Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio and Database Engine Tuning Advisor.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008 from different environments for the SSAS cubes.
• Helped in Designing Business Models as per requirement for SQL 2008 Analysis Services cubes.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008 from different environments for the SSAS cubes.
• Maintained production OLAP database development including Data Mining, changing dimensions, wrote MDX queries to generate reports using SQL Server 2008 Reporting Services.
• Thorough understanding of Kimball’s theory, KPIs, SQL 2008 Architecture.
• Excellent hands on experience with SQL Server Integration Service (SSIS), SQL Analysis Services (SSAS) and Reporting Services (SSRS).
• Designed Data Models using Erwin. Developed physical Data Models and created DDL scripts to create database schema and database objects.
• Experience with ADO.Net/ ASP.Net. C# for creating Crystal and Business Objects report.
• Involved in creating Dimensions, KPI, Measures and calculations.
• Created SQL Server Analysis Project using MS SSAS 2008. Created cubes in SSAS to be used as data source in the reports
• Analyzed the sources including Oracle, SAP R/3 and Flat file, and used Informatica Power Center and Power Exchange to create the source definitions.
• Create Informatica mappings to load into the dimension tables, facts tables and aggregated fact tables from staging area by using Transformations including Source Qualifier, Lookup, Filter, Aggregator, Sorted Procedure, Expressions, etc.
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view
• Developing and extending the cubes with around 50 dimensions, about 15 measures, and 25 calculated members, Design Dimensions and using the MDX expressions for the various Optimizations like Optimizing cube schema
• Identified and defined Fact relationships in SSAS, Created cubes and dimensions

Environment MS SQL Server 2008, SSIS, SSRS, SSAS, OLAP, OLTP, T-SQL, Stored Procedures, SQL Server Enterprise Manager, ETL, DTS, Performance Point Server, ADO.Net, C#, IIS 4.0, Visio 2000, Teradata, Informatica 8.1, SAP, Business Objects, SQL Server Query Analyzer, SQL Profiler, Erwin4.1, TIDAL job scheduler, Windows Office 2007/2003.

BI Developer

Confidential, Alpharetta, GA

Responsibilities:

• Installed SQL Server 2008/2008R2 installation on windows 2008 clusters. Installed and configured SQL Server Reporting Services.
• Migrated SQL Server from 2000 to 2008 versions. SQL Server upgraded In-Place from SQL Server 2005 to SQL Server 2008
• Applied partitioning on few huge databases for better maintenance and performance. Applied encryption on sensitive databases and documented the process for database refreshes
• Designed SSIS packages to automate the maintenance process
• Tuned existing SSIS packages to perform better
• Enhanced the database disaster recovery management and performed drills to fill up any gaps.
• Worked with end clients in capacity planning for designing new environments
• Trained the team to expertise in Database maintenance and corruption issues
• Performed SQL health check using DBCC commands
• 24/7 support provided with Offshore coordination.
• Communicate with corporate customers via telephone, written correspondence, or electronic service regarding problems identified in Microsoft SQL Server software.
• Troubleshooting issues related to tools, Management Studio/SEM, SQL Agent - scheduled tasks, Maintenance Plans, Import/ Export Wizard, Migration Advisor
• Troubleshooting security and permission related issues.
• Troubleshooting all type of memory related issues (like: out of memory error) and issues related to basic connectivity and full text search.
• Took care of all performance escalation issues like index management and statistics related issues
• Configured and Administered Replication, log shipping, Mirroring and Clustering.
• Performed regular duties like Backups, Restores.
• Created SQL jobs, Maintenance plans and scheduled them as required.
• Configured DB mail setup and notified stake holders of any job failures.
• Resolved SQL connectivity and security issues for technical and non-technical staff.
• Good understanding of Data Mining, Data Marts, Data Warehousing, Operational Data Store(ODS), OLAP, Star Schema modeling, Snow-Flake modeling, Fact and Dimensional tables using SSAS

Environment MS SQL Server 2000/2005, Windows 2008/2003 Server, SSRS, SSIS, Business Intelligence, T-SQL, DB2, DTS, Patrol, BMC Impact manager, SAP-CRM,XML,XSLT,ADO.Net, Erwin 4.0.

Confidential

SQL Server BI Developer

Responsibilities:

• Involved in Physical / Logical design of database, creating and managing the database and all the database objects.
• Worked with Implementation team and closely moved with end users to implement manufacturing solutions.
• Worked closely with developers, end users and Administrators in designing and creating databases and other objects.
• Actively involved in designing databases for the system.
• Created new tables, written stored procedures for Application Developers and some user defined functions.
• Created SQL scripts for tuning and scheduling.
• Performed data conversions from flat files into a normalized database structure.
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
• Regularly monitored the system for bottlenecks for CPU, RAM, Disk IO and Networking
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Creation/ Maintenance of Indexes for fast and efficient reporting process.

Environment MS SQL Server 2000, MS Access, DTS, Erwin 4.1, SQL Query Analyze, VB, Crystal Report, Windows Office 2000.