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’s BI series tools and SSRS using relational and multidimensional data.
• Experience in creating Report Models for building Ad hoc reports using SSRS.
• I have a good experience in the power query, power pivot, power view, power maps.
• Expertise in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.
• Experience in Administering, Managing and Troubleshooting Reporting services.
• Extensive Experience on Teradata database, analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverables with in committed timelines.
• Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, Multi Load, Fast Export, T pump, Visual Explain, Query man), Teradata parallel support and Unix Shell scripting .
• 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, Teradata, Oracle 9i/10g, PostgreSQL.

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

Tools: & Packages: SQL Server Management studio, Netezza, 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), power pivot, 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, Dallas, TX

Sr SQL BI Developer/SSIS/SSRS/SSAS Developer

Responsibilities:

• Created the Data Warehouse Architecture, Data Model and setting up the Best Practices.
• Created Tables, Cluster/Non-Cluster Index , Unique/Check Constraints , Views, Stored Procedures.
• Modified the stored procedures for the optimal performance of the system.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the data.
• Created indexed views and appropriate indexes to reduce the running time for complex queries.
• Advanced knowledge of Excel for using Pivot tables, Power Pivot, Complex formulas on the top of Tabular model.
• Developed efficient SSIS packages for processing fact and dimension tables with complex transformations.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Involved in Creating Data warehouse Star schema and snow-flake schema.
• Created ETL Projects using SSIS 2012 in Package Deployment Model as well as Project Deployment Model, also efficiently used SSIS catalog for ETL Monitoring.
• Migrated databases from .
• Transformed and merging data as per the requirement for ease of analysis in Excel by using Power Query in Power BI.
• Developed Charts and other visualization using Power View
• Filter and Sorting Data using Power View in Excel 2013
• Involved in Creating Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS.
• Responsible for the modifying and creating the existing SSRS reports in Power pivot report for drill-through purpose.
• Expert in designing reports using SQL server reporting services (SSRS) and Excel power pivot table based on OLAP Cubes.
• Trained the End-users to access OLAP Cube using Excel Power Pivot.
• Created Reports using SSRS and Created Parameterized reports Cascading reports using SSRS.
• Optimized the queries by looking at Execution Plan for better tuning of the database.
• Design and Develop new SSAS Tabular Models which uses xVelocity (formerly Veritpaq) in-memory engine.
• Provide Operational Support to modify existing Tabular SSAS models to satisfy new business requirements.
• Extensive use of DAX (Data Analysis Expressions) functions for the Reports and for the Tabular Models.
• Designed Dimensional Modeling using SSAS for End-User. Created Hierarchies in Dimensional Modeling.
• Extensive Knowledge in Creating Relationships, Measures, Partitions, Calculations using DAX and KPIs in SSAS Tabular model.
• Designed Perspectives and Hierarchies In SSAS Tabular model.
• Created Roles for SSAS Tabular Model provide additional Security at the row-level by using row-level filters.
• Extensive Knowledge in Creating Many-Many Relationships in SSAS Tabular model.
• Designed database maintenance plans, profiler and execution plans for stored procedure development and indexes for optimizing performance.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Expertise in developing Parameterized, Chart, Graph, Linked Dashboard report on SSAS Tabular model.
• Responsible for creating daily reports, Monthly Reports and Portfolio Dashboard for analyze the performance of the Business.

Environment: SQL Server 2014/2012/2008 R2,Powerpivot, Integration Services (SSIS), Analysis Services (SSAS), Reporting Services(SSRS), BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, MS SQL SERVER, T-SQL, MDX, Windows 95/NT/2000/2003, XML, MS Excel, visual studio 2008, visual studio 2012

Confidential, Akron, OH

Sr. SQL/BI /SSIS/SSRS/SSAS/ETL Developer

Responsibilities:

• Designed efficient ETL process to transform and load data from various sources to New Data Warehouse.
• Designed the New SSIS Packages Based on Existing Stored Procedures and views.
• Involved in Creating Data warehouse based on Star schema.
• 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 with complex transformations.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Data Load from various location to new Data warehouse and create the new stored procedures and convert the existing stored procedures to SSIS load
• Developed the Efficient ways of Restorability strategies in case of any SSIS Package failures.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Develop and deploy highly interactive, functional and complex analytics solutions that can meet the needs of multiple business roles and scenarios.
• Migrated databases from .
• Worked on the Teradata stored procedures and functions to confirm the data and have load it on the table.
• Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and historical data.
• Worked on optimizing and tuning the Teradata views and SQL’s to improve the performance of batch and response time of data for users.
• Configured and managed data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS.
• Extensively worked on OLAP cubes using SSAS.
• Created and Managed OLAP Cubes using SSAS.
• Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• 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.
• Involved in the development of the Business logic layer using C# and Data access layer using C# and ADO.NET.
• 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.
• Involved in the SSRS Reports discussions.
• Monitoring SQL server performance using SQL Profiler, Query analyzer, Index Tuning Wizard and Windows Performance Monitor.

Environment: SQL Server 2014/2012, Integration Services (SSIS), Analysis Services (SSAS), Reporting Services(SSRS), BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, MS SQL SERVER, T-SQL, MDX, Windows 95/NT/2000/2003, XML, MS Excel, visual studio 2008, visual studio 2012

Confidential, Dallas, TX.

Senior SQL/BI/SSIS/ETL Developer

Responsibilities:

• 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 with 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 building Star schema and Snow Flake schema depending on business requirements.
• Worked on Multidimensional Expressions (MDX) queries on Cubes.
• Configured and managed data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS.
• Created Cell Level Security in cubes using SSAS.
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Configured and managed data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS .
• Created Cell Level Security in cubes using SSAS .
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS .
• Worked on the Teradata stored procedures and functions to confirm the data and have load it on the table.
• Used Teradata Data Mover to copy data and objects such as tables and statistics from one system to another.
• Analyze business requirements, designs and write technical specifications to design and redesign solutions.
• Involved in Analyzing / building Teradata EDW using Teradata ETL utilities .
• Develop and deploy highly interactive, functional and complex analytics solutions that can meet the needs of multiple business roles and scenarios.
• 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
• 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.
• Created Cubes from which data can be retrieved rapidly by enterprise information consumers.
• Worked on Multidimensional Expressions (MDX) queries on Cubes.
• Experience in Modifying, Copying Adobe files containing embedded objects using Documentum
• Developing .Net assemblies in C# for business logic and data access.
• 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 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

Roles and Responsibilities:

• Build efficient SSIS packages for processing fact and dimension tables with 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.
• Involved in building Star schema and Snow Flake schema depending on business requirements.
• Worked on Multidimensional Expressions (MDX) queries on Cubes.
• Configured and managed data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS .
• Created Cell Level Security in cubes using SSAS .
• 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 with failed jobs or data discrepancy.
• 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 with 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

SQL 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, Netizza, UNIX, XML,XSLT, ADO.Net.

Confidential, Dallas, TX

SQL/BI 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 with 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 with 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 with 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, Netezza, BIDS, MSMS, Microsoft Reporting Service (SSRS), SQL Server Integration Services (SSIS), .NET, C#, ASP.NET, ADO.NET

Confidential

SSIS/SSRS Developer

Roles and 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