SUMMARY

• Over 8 years of experience in Microsoft Database Technologies that includes experience in Database Design and Development in Financial, Retail and Healthcare Domains.
• Extensive experience in Database Design, Data Modeling, T - SQL Development, Developing and Implementing ETL Packages using SSIS and Complex Reports using SSRS.
• Experience in writing Efficient T-SQL queries, Stored Procedures, User Defined Functions, Database Triggers and Exception Handlers.
• Expert in configuring and creating SSIS solutions for high performance Data Integration, Data Migration and Business Intelligence Process that includes Merging Data from various Heterogeneous Data Stores, Populating Data Warehouses and Data Marts, Cleaning and Standardizing Data.
• Experience in implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.
• Experience in Administering SSIS packages such as Scheduling package execution, backing up and Restoring packages, Monitoring Integration services Performance and activity, and implementing Security considerations for SSIS Packages.
• Experience in designing, creating and managing Cubes using SSAS.
• Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies using SSAS.
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Good experience building star schema and snowflake schema depending on the business data requirements.
• Experience in Deploying and Monitoring Analysis services.
• Extensive knowledge of Designing, Developing and deploying various kinds of reports using Cognos BI series tools and SSRS using relational and multidimensional data.
• Experience in creating Report Models for building Ad hoc reports using SSRS.
• Expertise in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.
• Experience in Administering, Managing and Troubleshooting Reporting services.
• Worked on administration tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, upgrades, creating databases/File groups/files/Transaction logs.
• Extensive knowledge in Tuning SQL queries, T/SQL queries and improving the performance of the Database using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Experience in C#/.NET application development environment to use SQL Server Databases.
• Excellent communication, interpersonal and analytical skills.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2000/2005/2008/2012 , MS Access, Oracle 9i/10g, PostgreSQL.

Programming Languages: VB scripts, C, C# and UNIX Shell Script.

Tools: & Packages: SQL Server Management studio, Enterprise Manager, Profiler, Business Intelligence Development studio (BIDS), DTS, ETL, Visual Studio .NET.

Operating Systems: Windows Vista/XP/2003/2000, Windows Server 2000/2003/2008.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), DTS, SQL Server Analysis Services (SSAS), MS Visio, Erwin, Crystal Reports 9.0/XI, Documentum, ProClarity, Performance Point Server.

Web Technologies: XML, HTML, XSL, IIS.

Application Packages: MS Office Suite, MS Outlook, Microsoft Office SharePoint Server (MOSS).

PROFESSIONAL EXPERIENCE

Confidential, Wichita, KS

Senior BI/SSIS/SSRS Developer

Responsibilities:

• Designed efficient ETL process to transform and load data from various sources through ESB across the enterprise.
• Created Efficient Stored Procedures, Triggers, and Functions, Indexes, Tables, Views and other T-SQL scripts.
• Extracted, Transformed and Loaded source data into respective target tables to build the required data marts.
• Developed efficient SSIS packages for processing fact and dimension tables wif complex transformations.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.
• Developed the Efficient ways of Restart ability strategies in case of any SSIS Package failures.
• Responsible for report generation using SQL Server Reporting Services (SSRS) and Crystal Reports based on business requirements.
• Involved in Creating Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS.
• Created Reports using SSRS and Created Parameterized reports Cascading reports using SSRS.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Migrated databases from SQL to DB2
• Migrated Legacy Oracle and DB2 databases to SQL Server
• Created Cubes from which data can be retrieved rapidly by enterprise information consumers.
• Worked on Multidimensional Expressions (MDX) queries on Cubes.
• Creating Data Points for use by Decision engine using T-SQL, Stored Procedures and Functions.
• Designed automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity.
• Experience in Modifying, Copying Adobe files containing embedded objects using Documentum
• Developing .Net assemblies in C# for business logic and data access.
• Involved in the development of the Business logic layer using C# and Data access layer using C# and ADO.NET.
• Configured and managed data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies wif SSAS.
• Created Cell Level Security in cubes using SSAS.
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Involved in Weekly database maintenance plans and also tuning the databases and applications for better performance.
• Created and maintained Database Projects for efficient application development and deployment.

Environment: SQL Server 2014/2012/2008/2005 , Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, Index Analyzer DTS, MS SQL SERVER, T-SQL, Documentum, DB2, MDX, Windows 95/NT/2000/2003, XML, MS Excel and MS Access, Visual Team Foundation Server, Crystal Reports, TOAD, visual studio 2008,visual studio 2012 .

Confidential, Dallas, TX

SQL Server Developer/SSIS/SSRS Developer

Responsibilities:

• Build efficient SSIS packages for processing fact and dimension tables wif complex transforms.
• Extract, Transform and Load source data into respective target tables to build the required data marts.
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.
• Created Efficient Stored Procedures, Triggers, and Functions, Indexes, Tables, Views and other T-SQL scripts.
• Worked on creating Tabular Data Model Databases and created SSRS reports on top of it using both Direct Query and Cached Modes.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Involved in Creating Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS.
• Modified the existing stored procedures to meet new design.
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Involved in Creating Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS.
• Developed Report Models for building customized Ad hoc reports. Played a Content Manager role on report server.
• Creating and maintaining automated jobs for database backup on a weekly basis based on the percentage used and made sure the backup is current.
• Monitoring SQL server performance using SQL Profiler, Query analyzer, Index Tuning Wizard and Windows Performance Monitor.
• Designed automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity.
• Designed Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Creating and Maintaining various instances or environments of SQL Server for Development and Testing.
• Monitoring and scheduling daily, weekly and monthly SQL Server jobs and debugs any issues related wif failed jobs or data discrepancy.
• Involved in building Star schema and Snow Flake schema depending on business requirements.
• Worked on Multidimensional Expressions (MDX) queries on Cubes.
• Replicating the data bases from Production to the warehouse on a live basis.
• Coordinating the Releases through MRP (Master Release Plan).
• Cleaning up the QA environments after every release and rebasing the environments wif current data.
• Monitoring SQL Error Logs, Scheduling Tasks, Database Activity, Eliminating Blocking and Deadlocks.
• Involved in setting up the SQL scripting standards to the developers.
• Creating Data Points for use by Decision engine using T-SQL, Stored Procedures and Functions.
• Creating Triggers on various Data base tables to maintain business rules.
• Responsible for Query optimization and Performance tuning.
• Involved in Debugging Issues as a part of Production Support.

Environment: Microsoft SQL Server 2008 R2, T-SQL, SSIS, SSRS, Visual Source Safe, MS Excel, Performance Point Server 2007.

Confidential, Richardson,TX

BI /SSIS/SSRS Developer

Responsibilities:

• Created the Data warehouse Architecture, Data Model and setting up the Best Practices.
• Built the Source to target mapping document based on Subject areas for ETL Data Integration initiative.
• Created Star Schema from analyzing the underlying requirements of the data ware house.
• Created indexed views, and appropriate indexes to cut the complex query run time.
• Involved in setting up the SQL scripting standards to the developers.
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.
• Created ETL Projects using SSIS 2012 in Package Deployment Model as well as Project Deployment Model, also efficiently used SSIS catalog for ETL Monitoring.
• Created efficient ETL packages to load data from CSV, 834 Edi files, Password Protected Excel and pgp encrypted files stored in SFTP and FTP.
• Worked on creating Tabular Data Model Databases and created SSRS reports on top of it using both Direct Query and Cached Modes.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Involved in Creating Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS.
• Modified the existing stored procedures to meet new design.
• Monitoring SQL Error Logs, Scheduling Tasks, Database Activity, Eliminating Blocking and Deadlocks.
• Developed SQL Server Maintenance plan, scheduling of Jobs, Alerts and Troubleshooting.
• Wrote efficient Stored Procedures and functions according to the business requirements for internal applications.

Environment: MS SQL Server 2012/2008, Windows Server 2008, SSMS, BIDS,SSRS, SSIS, SSAS, Report Builder 3.0,Report Model, Erwin, Team Foundation Server, Performance Point Server, ProClarity, SharePoint (MOSS), FTP, MS-Visual Studio, UNIX, XML,XSLT, ADO.Net.

Confidential, Dallas, TX

SQL SSIS/SSRS/SSAS Developer

Responsibilities:

• Supported Enterprise ETL Development and support for various Business Divisions interfacing Microsoft Applications.
• Collected business requirements from users and translated them as technical specs and design docs for development.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2005 using SSIS, BCP and Bulk Insert.
• Created ETL packages to load everyday transactional data into Data warehouse and BCP to build analysis services cubes and create SSRS reports on top of the cubes to provide quarterly forecast about each product to the client.
• Established ETL design practices for optimization and performance of packages and Parameterized SSIS packages wif the use of environment variables
• Automated ETL Data loads and established efficient ways of Error Handling in SSIS
• Installing Performance Point Server and Share Point
• Created Dash Boards and Score Cards and integrated them wif MOSS.
• Involved in Heavy MDX scripting for writing business calculations.
• Implemented Slowly Changing Dimensions
• Created Scattered, Bar and Chart reports using SSRS 2008
• Created Score Cards and Reports and published them wif MOSS 2007
• Created Reports using SSRS and Created Parameterized reports Cascading reports using SSRS.
• Created Charts, Gauge reports using Dundas Charts.
• Established naming and documentation standards.
• Created complex variables, multiple breaks, sorts in the reports using SSRS.
• Diagnosing and tuning the server optimal performance using Dynamic Management Views (DMV), Profiler and Index Tuning Wizards
• Monitored SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks user counts and connections/locks etc.
• Created UAT documents and performed unit and system test processing.

Environment: Server 2005/2008 Enterprise, BIDS, MSMS, Microsoft Reporting Service (SSRS), SQL Server Integration Services (SSIS), .NET, C#, ASP.NET, ADO.NET

Confidential

SSIS/SSRS Developer

Responsibilities:

• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.
• Creating functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
• Converted packages from DTS to SSIS.
• Created packages and scheduled them for automation.
• Created ETL packages for data conversion using various transformations tasks.
• Experience in building star schema and snowflake schema depending on the business data requirement.
• Responsible for Query optimization and Performance tuning.
• Used SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries.
• Developed List, Summary, Cross-Tab and Drill through reports using SSRS.

Environment: SQL Server 2005, BIDS, MSMS, SQL Server Integration Services (SSIS), .NET, C#, ASP.NET, ADO.NET