PROFESSIONAL SUMMARY:

• 8 years of professional experience in production support, database design, data - modeling, datawarehouse desing & development and administration with MS SQL Server using T-SQL, SSIS, SSAS, SSRS in Banking & Financial, Retail, and Healthcare industries.
• Experienced with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Extensive experience in Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS) and MS SQL Server Analysis Services (SSAS).
• Created, Built and deployed successfully dynamic SSIS packages into SQL Server 2012/2008/2005 databases and scheduled them according to requirements.
• Experienced in installing, configuring, managing, monitoring and troubleshooting on SQL Server
• Simulation and Validation of data using different excel opertations like: vlookup, sorting, filtering Macros.
• Creating and presenting reports in Excel by using formula function, table piviting, cross referencing & macros.
• Experience in using Informatica Client tools: Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Excellent experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server by using SSIS and DTS (Data Transformation Services) utility.
• Experienced in designing high level ETL architecture for overall data transfer from the OLTP - Online Transaction Processing to OLAP - Online Analytical Processing with the help of SSIS.
• Strong experience in designing and developing large number of reports in SSRS/Business Objects using the data from ETL Loads, MS SSAS Cubes and various heterogeneous data sources.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
• Expert in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Experienced in developing and modifying cubes using SSAS and transform into pivot table.
• Expert in developing and modifying multi-dimensional cubes using SQL Server Analysis Services (SSAS)
• Experienced in using XMLA protocol for SQL Server Analysis Services for interaction between client application and instances of Analysis Services.
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Expert in developing Drill through and Drill down reports using Crystal Reports and MS SQL Server Reporting Services (SSRS)
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Strong experience in logical and physical database design and development, Normalization and data modeling using CA Erwin and MS SQL Server Enterprise manager.
• Analyze requests from client/end-users for custom code, new reports, new batch processes, newDB2 SQL's queries, etc.
• Experienced in implementing Key Performance Indicator (KPI) Objects in SSAS.
• Efficient in up-gradation and migration from SQL Server 2000 to SQL Server 2008/2005.
• Good experience on PL/SQL programming at developer and designer level.
• Experienced in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Excellent inter personal and communication skills and ready to take challenges with proven ability.

TECHNICAL SKILLS:

Databases: MS SQL Server 2005/2008/2008R2/2012 Oracle 11g/10g/9i/8i, Sybase Server, IBM DB2 UDB 8.2/8.0, MS Visual Source Safe 2005 and MS Access

Database Tools: Enterprise Manager, Query Analyzer, SQL Server Management Studio (SSMS), SQL Profiler, Upgrade Wizard, Replication, Database Engine Tuning Advisor, SoalrWinds Database Performane Analyzer (DPA)

Reporting Tools: SQL Server Reporting Services(SSRS), Crystal Reporting

ETL Tools: SQL Server Integration Services(SSIS), Data Transformation Services(DTS), BCP, SQL Server Analysis Service(SSAS), Informatica, Business Intelligence Development Studio (BIDS)

Languages: T-SQL, DB2, PL/SQL,VB.NET, C#

Web Technologies: Web Services, XML, HTML

Applications: Microsoft Windows Enterprise, MS Visual Studio, Lifepro, MS Office, Workfront, OnBase, TFS

IT Processes: Software Development Life Cycle (SDLC), Agile, Scrum, Waterfall

Data Modeling: MS Visio, ERwin 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, Physical & Logical data modeling and De-normalization

Scheduler: CA Workload Automation Workstation (EE/ESP), Autosys

Banking: Automated Clearing House, Banking Clelaring System, Electronic Funds Transfer (EFT)

PROFESSIONAL EXPERIENCE:

Confidential, Benefits, TX

SQL Developer/ Productin Support Specialist

Responsibilities:

• Providing L2/L3 Technical Support for ESP Application and Batch Processing
• Providing L2/L3 Support for SSIS package through ESP automation
• Involving in Product Move from Development Environment to Production Environment.
• Providing 24×7 operational support including holidays and weekends
• Creating ESP Job APPLS for automation process as per the requirement
• Working and fixing different issues in Lifepro tickets and running AutoHot Key Script to update lifePro
• Creating, Configuring of different ESP APPLS as per the requirement of QA and Developer team and providing support facility by debugging and fixing the issues.
• Involving in Change Management process for deployment of change on Prod Environment
• Debugging and Analyzing of mainframe batch abend and fixing in a shortest possible time to deliver a regular production cycle without any delay
• Writing SQL statements to provide back-end solutions for production issues, monitoring and reporting
• Responsible for tracking of trouble tickets and resolution of escalated tickets
• Answering Technical Support queries and implementing fixes for application problems
• Creating and maintaining documentation for Supported Applications
• Fixing to problems by own responsibility and rectifies error by modifying the system and/or database making use of various modules like SQL
• Working on Cross functional teams to proactively address product issues.
• Monitoring all alerts and escalate all issues for all procedures and system
• Conducted Code reviews and adhere to Change control methodologies across UAT, Prod environments.
• Working on data collection, data analysis, data cleaning, performance tuning, troubleshooting and debugging.
• Checks Sessions and error logs to troubleshoot problems and also used debugging for complex Problem troubleshooting.
• Planned, Defined and Designed data based on business requirement and provided documentation.
• Gathered data and documenting it for further reference and designed Database using Erwin data modeler.
• Created SSIS package to load data from Flat different datasource by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate and Load data to Data Warehouse and Data Mart Databases.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis using SQL Server Agent.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
• Worked in setup logging environment to track the status of the events like error raise, task fail.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Generated Conditional, Drilldown reports, Drill through reports and parameterized reports using SSRS 2012.

Tools & Technologies: MS SQL Server 2012, SSIS, T-SQL, SSRS, SSAS, CA WA workstation, Lifepro, MS Visio, Microsoft windows Enterprise 2007, OnBase, HPSM, Sharepoint, TFS, MS Visual Studio, AutoHot Key.

Confidential, Winston-Salem, NC

SQL/ SSIS/ SSRS Developer

Responsibilities:

• Created SSIS package to load data from Flat Files and SQL Server 2008R2 to SQL Server 2012 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Designed SQL stored procedures for mortgage lender information.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis using SQL Server Agent.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
• Worked in setup logging environment to track the status of the events like error raise, task fail.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2012.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Generated Conditional, Drilldown reports, Drill through reports and parameterized reports using SSRS 2012.
• Develop and produce a mortgage portfolio for consumer market.
• Created reports to retrieve data using Stored Procedures that accepts parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created calculated measures and dimension members using multi-dimensional expression (MDX).
• Generated Dashboards, Sub-Reports, Drilldown-Reports, Summary reports, and Matrix reports using both T-SQL variables and MDX.
• Created cubes, dimensions and MDX queries using SQL Server Analysis Services (SSAS).
• Develop SSAS cubes, tabular models, MDX/DAX queries, Performance Point, Power View, Power Pivot reports and dashboards.
• Work closely with QA/UAT team and fix the defects during system integration testing.
• Created various database object like stored procedures, functions, tables, views
• Configured the report viewing security for various users at various levels using Report Manager
• Scheduled report and exported in different formats.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Involved in monitoring and deployment of SSIS packages across Dev, UAT, and production environments using dtexec utility, command prompt with .bat files etc.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS). Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Created various variables and deliver them into XML configuration files to make SSIS
• Parsing XML documents into relational data, and composing XML documents from relational data using XML stage.
• Involved in managing the corporate EDI projects.
• Conducted Code reviews and adhere to Change control methodologies across UAT, Prod environments.
• Working on data collection, data analysis, data cleaning, performance tuning, troubleshooting and debugging.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex Problem troubleshooting.
• Troubleshoots ETL issues, validates result sets, recommends and implements process improvements.
• Responsible for code development using PL/SQL, Unix Scripting, XML tags to publish data.
• Provided documentation for all kinds of reports and SSIS packages.
• Performed maintenance on the General Ledger System of the company using MS-COBOL. This included adding, editing and testing of programs on the GL System.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

Tools & Technologies: MS SQL Server 2012/2008, SSIS, T-SQL, SSRS, Win 2008 Advanced Server, VSS, EDI, Troubleshooting

Confidential, Chantilly, VA

Data Analyst/ MS SQL Server Developer

Responsibilities:

• Developed system standards, architecture, scenarios, detailed screen specifications and documented logical and physical data model using ERwin Data Modeler.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS.
• Worked Extensively with MS SQL Server Integration Services (SSIS) to import, export and transform the data between the linked servers.
• Created packages using MS SQL Server Integration Services (SSIS) for data extraction from Flat Files, Excel files, OLEDB source to data warehouse.
• Used SSRS to create reports, customized reports, On-Demand reports and Ad-Hoc reports and involved in analyzing multi-dimensional reports in SQL Server Reporting Services 2008.
• Documented all Facets claims business requirements for mapping to the EDW.
• Wrote the Security Profile User Documentation Instructions for the IS Security Team to to configure new user and new group profiles Facets.
• Created Install instructions and deployment documents for the Test/UAT/Production Environments.
• Developed stored procedures, triggers and functions to account for some automated insertion of records in some of the tables.
• Used BCP utility and Bulk Insert to load data from different data sources to SQL Server.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Worked on creating Store Procedures for QNXT, CCMS and Echo application.
• Managed users including creation/alteration, grant of system/database roles and permission on various database objects.
• Tested and configured automated routine maintenance tasks like performance tuning, indexes and stored procedures, checked deadlocks and created jobs and scheduled them.

Tools and Technologies: MS SQL Server 2008/7.0, Windows Server, Windows NT, Erwin, Facets, Crystal Reports

Confidential, Sunnyvale, CA

MS SQL Server Developer/SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirement and provided documentation.
• Engaged in gathering data and documenting it for further reference.
• Involved in installation and configuration of MS SQL Server 2008.
• Expert in designing database using ERWIN.v7.2
• Upgraded the server from MS SQL Server 2005 to MS SQL Server 2008.
• Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column, and etc.
• Created SSIS packages for data Importing, Cleansing, and Parsing.
• Developed Unit Test Plans for SSIS packages.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on daily basis.
• Designed, developed, and deployed reports in MS SQL Server environment using SSRS
• Validation of data using different excel opertations like: sorting, filtering, Macros.
• Creating and present reports in Excel by using formula function, table piviting, cross referencing.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Generated various reports using SSRS 2008.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for monitoring and tuning report performance.
• Configured the report viewing security for various users at various levels using Report Manager
• Scheduled report and exported in PDF format.
• Extensively used the Teradata utilities like BTEQ, Fast load, MultiLoad, DDL Commands and DML Commands (SQL) Created various Teradata Macros in SQL Assistant for to serve the analysts.
• Fine-tuned SQL Queries for maximum efficiency and performance.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Provided documentation for all kinds of reports, Stored Procedures and SSIS packages.

Tools and Technologies: MS SQL Server 2008, SSIS, SSRS, SSAS, Oracle10g, Visual Studio 2005, VSS 2005, Erwin 7.3

Confidential, San Francisco, CA

MS SQL/SSIS/SSRS/SSSAS Developer

Responsibilities:

• Designed an OLAP with the help of Erwin 7.1.0 to visualize data structure.
• Created complex Stored Procedures, SSIS (Data Transformation Service) packages, triggers, cursors, tables, views and SQL joins and statements for applications.
• Developed T-SQL (DDL-Data Definition Language, DML-Data Manipulation Language) statements using dynamically generated SQL.
• Worked with Tivoli Workflow scheduler and Hyperian query analyzer along with toad.
• Working with and verifying eCommerce data.
• Extracted and reviewed data from heterogeneous sources from OLTP to OLAP using SQL Server Integration Services (SSIS).
• Payroll patch and hrglobal patch and Hyperian db and BI install and weblogic 10.2.4
• Performed Cognos administrative tasks including installation, security and deployment.
• Modified cube partitions to optimize the query performance of the cubes
• Created MS SQL server Analysis Projects and created multi-dimensional databases and OLAP cubes and dimensions for the analysis of sales in specific areas using MS SSAS.
• Defined Referenced relationships with the measure groups and fact tables.
• Improved query performance by cube partitioning.
• Reviewed and changed the cubes in the data marts for product valuation based on the revenue opportunities using MS SSAS 2005.
• Analyzed various dimensions and facts that could be included in Data Mart design using best suited Star-Schema and created logical and physical model of Data Mart in ERwin.
• Developed MDX expressions for cube calculations and KPIs.
• Implemented the calculations to aggregate physical measures using management studio.
• Mapped Data Mart with existing data warehouse by properly analyzing dependencies.
• Generated daily, weekly, monthly, quarterly, and annual reports using MS SSRS.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Extensively used Profiler to identify and repair database lockups, deadlocks, and other issues.

Tools and Technologies: MS SQL Server, Hyperian, MS SSAS, MS SSRS, MS SSIS, DTS, T-SQL, VB Script, Erwin 7.1