SUMMARY

• Over 8+ years of extensive experience in database design, development and administration with MS SQL Server versions 2014/2 R2/2005 using SSIS, SSAS, SSRS (BI Tools) in Financial, Telecommunication and Banking industries.
• Good Business and System analysis skills to understand the requirements and customize client applications.
• MS SQL Server Developer 2012/2008R 2/ 2008/2005/2000 with 8+ years of IT experience in various Industry verticals like Health Care, Finance, Insurance and Service. Maintained positive communications and working relationships Confidential all business levels.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.
• Experience in analytical Database Design and Data Modeling skills using MS Visio and ERWIN.
• Expert in ETL - Extraction Transformation Loading/SSIS, Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
• Expert knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL/SSIS processes, dimensional modeling and reporting tools.
• 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.
• Experienced in designing high level ETL/SSIS architecture, creating, configuring and fine tuning ETL workflows designed in DTS/SSIS for overall data transfer from the OLTP to OLAP/EDW with the help of SSIS.
• Expert in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS 2012/2008R 2/2008/2005.
• Expert in developing Drill through and Drill down reports using Crystal Reports and MS SQL Server Reporting Services (SSRS)
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled DTS and SSIS Packages
• Efficient in up gradation and migration from MS SQL Server 2005 to MS SQL Server 2008
• Hands on experience in production/staging/test/development database administrative: Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.

TECHNICAL SKILLS

• MS SQL Server 2014/2012/2008 R 2/ 2008/2005/2000
• MS SSRS 2008/2005/2000
• MS SQL SSAS 2008/2005/2000
• MS SSIS 2008/2005/2000
• DTS
• Erwin
• Oracle 10g
• Power designer
• DB2 SQL syntax
• MS-Access 2000
• C
• C++
• VB 6.0
• Developer 2000
• Erwin 7.3/4.2/4.2/4.0
• Oracle 9i/10g
• T-SQL
• PL/SQL
• ASP.NET
• HTML
• XML
• XSL
• Visual Studio 2005
• T-SQL
• PL-SQL
• Crystal Reports
• ODBC
• MS Office
• Windows NT/ 2000 Server/ XP.

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Sr. MS SQL Server/Teradata /SSIS/SSRS/ DBA

Responsibilities:

• Reviewed and analyzed business needs and developed Technical Specifications based on interaction with Managers and Development Teams.
• Migrated historical video data from Teradata and SQL Server.
• Designed and developed the ETL platform using SSIS for moving the raw video log files from windows landing pad to HDFS, separated the logs by module, parsed the files and created module based hive tables.
• Worked on number of data migration project from Teradata to SQL and SQL to Teradata based on the requirements.
• Designed developed and maintained complete process from receiving raw logs from STBs and mobile devices, archiving files, and wrote number of parsing scripts to parse huge raw logs based on modules.
• Designed and developed ETL processes, wrote complex queries, functions, published reports for end users, for CRM applications, campaigns, and reporting projects to help increase revenue, upsell, decrease churn.
• Developed complex ETL processes to scan the viewership of networks across various and send lead lead-list to the marketing/content team for upsell/content cost settlements.
• Designed and developed reports like ARPU, GATB, Net Adds, Self-Serve, Churn, Viewership metrics which provides KPI metrics on FiOS TV, CE Mobile, Flex View, and TV everywhere data.
• Proficiently worked with various Teradata utilities like Bteq, Mload, Tpump, Fexp, OleLoad.
• Used BTEQ andSQL Assistant(Query man) front-endtools to issue SQL commands matching the business requirements to TeradataRDBMS.
• Architected and developedFast LoadandMLoadscripts in control file.
• Worked on Team Foundation Server (TFS) and source control to maintain a repository of T-SQL, SSIS, SSRS, SSAS, BTEQ Scripts developments and for the version control of the items being worked by various members in the team.
• Proficient in data warehousing techniques for data cleaning, Slowly Changing Dimension phenomenon, surrogate key assignment and CDC (change data capture), Audit table, Error Handling Techniques for ETL process.
• Worked on Multi-dimensional Objects (Cubes, Dimensions, Majors) usingSQLServerAnalysis Services (SSAS).
• Worked on SQL Server Reporting Services with Report authoring, Report management, Report delivery and security.
• Designed and developed database objects like Batch Scripts, Stored Procedures, Triggers, Views, Cursors, Indexes and User Defined Functions consumed Confidential various stages of Migration/Cleansing process, Reports or Data Validation.
• Designed and developed number of SSRS reports such as Drill down, Drill through, Parameterized, Cascaded parameterized, Linked, Chart, and Sub-reports based on requirements to create reports like ARPU, GATB, Net-Adds.
• Worked in development of numerous fact and dimension tables on top of huge video data and assisted creating OLAP model cubes, KPI’s Score Cards and Dashboards.
• Successfully adapted offshore- onsite model and made the project cost effective.
• Managed and mentored offshore resources to get work done from offsite while taking requirements from the Business users.

Environment: MS SQL Server 2008-R2, TERADATA 13.0, MS Visio008, BIGDATA, TFS,, Hadoop, Map Reduce, HDFS, Hive, Pig, HBase, Sqoop, Hue, Python, WorkBench, UNIX Shell Scripting, MySQL.

Confidential, Jersey City, NJ

SQL Developer /SSIS/SSRS Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of Clients.
• Involved in preparing Technical specification document based on the BRD and interact with the Business Analyst to analyze and understand the Business needs.
• Created various SQL objects such as schema, tables, field definitions and mappings, stored procedures, CTE, Triggers, views and indexes/keys.
• Involved In migration of various objects like stored procedures, tables, views from Oracle 10g to SQL server.
• Involved in compiling of store procedures in SQL server and troubleshoot errors.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of hub.
• Conducted performance tuning of complex SQL queries and stored procedures by using SQL Profiler and index tuning wizard.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.
• Created Dynamic SSIS Packages using package configuration, variables and expressions to load data in various environments.
• Involved in creating dynamic reports using SSRS for the monthly Claims and details of all locations, generated report models using report builder for the end users.
• Involved in scheduling reports on hourly, daily, weekly basis that contains reconciliation data between source and target and also reports to provide business with member’s and policy information.
• Generated Complex reports like reports using Cascading parameters, Snapshot reports Drill- down Reports, Drill-Through Reports, Parameterized Reports and Report Models and ad hoc reports using SQL Server Reporting Services (SSRS) based on Business Requirement Document.
• Create various Metadata driven reconciliation Stored Procedures to compare the data from Source to data warehouse and data warehouse to Reporting Data Store and display the inconsistency between them in reports and fix it.
• Experienced as aDeveloperinBizTalk Server2009/2006 R2/2006/2004
• Customize SharePoint 2010 solution as per business need such as setting up versioning, approval process and list throttling for list.
• Create document library for document management and configure SSRS integration for SharePoint 2010.
• Developed ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Provided Production support to analyze and fix the problems and errors on daily basis by modifying SSIS Packages and Stored Procedure if necessary.

Environment: T-SQL, MS SQL Server Integration Services 2012,MS SQL Server Reporting Services 2012, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio, Erwin, Windows XP, MS Office 2007/2010, MS Access, Power Pivot, CADIS 8.1.

Confidential, Des Moines, IA

SQL Server /SSIS/SSRS Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface the database and other applications in most efficient manner.
• Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.
• Created SSIS package to load data from XML Files, SQL Server 2005 and Teradata 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.
• UsedTeradata utilities fastload, multiload, tpumpto load data.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management using Tableue.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• 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.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2012.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created various database objects like stored procedures, functions, tables, views.
• Involved in the design and development of web forms for the application using ASP.Net to take care the cosmetic works of the reports deployed on the server.
• Created and published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Configured the report viewing security for various users Confidential various levels using Report Manager.

Environment: MS SQL Server 2008R2, T-SQL, SQL SSIS, SSRS, SSAS, BIDS, Windows server 2003 Visual Source Safe, SQL Profiler, Visual Studio 2008, Visual Intercept Enterprise Edition, Oracle 10g, VB.Net, VSS 2005, Erwin v7.3, Windows NT/2003, Microsoft .NET framework 3.5.

Confidential, Addison, TX

SQL /SSIS/SSRS Developer

Responsibilities:

• Create data pull procedure, SSIS packages and data or evidence documentation involve with different work stream.
• Perform manual tasks (downloading data files from third party vendor website, treasury report, excreta), Generate data samples for monthly processing.
• Compare the discrepancies between SQL script and SSIS package which are transitioning from manual to automate.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the Teradata and Oracle to SQL server.
• Developed packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources.
• Improved Performance of the database by creating Clustered and non clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Enforced data consistency by adding data viewer to the transformations and created dynamic packages by using variables to store the data into SQL.
• Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending mails upon package deployment.
• Migrated packages from development server to production server using package configuration.
• Involved in creation of fact and dimension tables in the OLAP database and created cubes using MS SQL Server Analysis Services (SSAS).
• Extensively used SQL Server Reporting Services 2008 with relational and multidimensional data.
• Worked on version Control using visual source safe.
• Involved in creating C# scripts using script task in SSIS
• Created dynamic reports using SSRS for the monthly connections and details of all locations, generated report models using report builder for the end users.
• Scheduling reports on a weekly basis that was generated every Friday containing the details of weekly sales for our location for assessing the business for that week.
• Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views in the centralized SQL database.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Involved in a data migration process between different versions ofCognos.
• Experienced in developing Dashboards Reports inCognos8 and 10.
• Performed data cleansing by creating tables to eliminate the dirty data using SSIS.
• Created User Defined Functions, indexes to generate the distinct data based on the type of the customer base.

Environment: MS SQL Server 2012/2008R2/2008, SSIS,SSAS,SSRS 2008, T-SQL, Visual Studio 2008, MS Office 2007/2003, SQL Profiler, Windows 2000/2003/XP,ADO.NET 3.5/3.0,ASP.NET 3.5/3.0.

Confidential, Middletown, NJ

SQL Server /SSIS/SSRS Developer

Responsibilities:

• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Created SSIS Packages to transfer data from various sources like Text Files, XML (Extensible Markup Language) Files, SQL Server, Excel and Access to SQL Server.
• Involved in upgrading packages from SQL server 2005 to SQL server 2008
• Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
• Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• 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.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008.
• Involved in creating OLAP cubes and dimensions for the analysis using SSAS.
• Created a cube using multiple dimensions and modified the Relationship between a Measure Group and a Dimension, created calculated members and KPI’s, using SSAS.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Involved in the design and development of web forms for the application using ASP.Net to take care the cosmetic works of the reports deployed on the server.
• Used “SQL Profiler TSQL Duration” template for tracking execution time of TSQL Statements.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor

Environment: MS SQL Server 2008/2005, SSIS, SSRS, SSAS, Visual Studio 2005, VSS 2005, Erwin 7.2, Windows NT/2003,Microsoft .NET framework 3.5, C#, XML

Confidential, Newark NJ

SQL Developer/SSIS/SSRS Developer

Responsibilities:

• Responsible for Conceptual, logical and physical design with a significant effort towards application using ERWIN.
• Involved in designing the data warehouse and core Database for the system including tables, Stored Procedures, Indexes, UDF and triggers.
• Performed operations such as Fine-tuning queries and stored procedures and providing consultation to other developers.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Used Query Analyzer and SQL Server Profiler for tuning report queries and improves performance in SQL Server.
• Performed activities like analyzing and improving the architecture of databases, creation & indexing of the tables.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Designed SSIS Packages in SQL Server 2008 to handle data migration (ETL Processes) from transaction System to Dimensional Model.
• Implemented SSIS (ETL) to extract and transform data from RDBMS and Flat files/CSV, SQL Server 2005, instances, Oracle Databases and to load into staging and then to DW for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Configured SQL Mail agent for sending automated alerts/email.
• Gather requirements from users Confidential chat sessions and interviews.
• Adept Confidential preparing business requirements documents, defining project plans, writing system requirement specifications.
• Developed Pl/Sql procedures & functions to support the reports by retrieving the data from the data warehousing application.
• Provided documentation for all kinds of reports and SSIS packages.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.

Environment: Microsoft SQL Server 2008/2005 Enterprise edition SP3, SSMS, SSIS, SSRS, SSAS, BIDS, Microsoft Visual studio 2005, Windows server 2003.