PROFESSIONAL SUMMARY

• Over 6+ years of extensive experience in database design, development and administration wif MS SQL Server versions 2014/2012/2008/2008R2 using SSIS, SSAS, SSRS (BI Tools) in Financial and Banking industries.
• Good Business and System analysis skills to understand the requirements and customize client applications.
• MS SQL Server Developer 2012/2008R2/2008 wif 6+ years of IT experience in various Industry verticals like Health Care, Finance, Insurance and Service. Maintained positive communications and working relationships at all business levels.
• Conversant wif 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 wif the halp of SSIS and also Involved in creating C# scripts using script task in SSIS
• 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
• 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/2008R2/2008/2005.
• Creadted SSRS reports from SharePoint.
• Expert in developing Drill through and Drill down reports using Crystal Reports and MS SQL Server Reporting Services (SSRS).
• Experience of analyzing data, and interpreting financial cost models.
• Performed cost analysis and developing financial models for mortgage project.
• 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 TEMPeffective team member wif excellent analytical, troubleshooting, and problem solving skills.
• Knowledge of SAP System and tools.

TECHNICAL SKILLS

• MS SQL Server 2014/2012/2
• 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
• MySQL MS office
• Excel PowerPoint.
• 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
• C# HTML
• XML XSL
• SharePoint 2010
• SAP Tool
• Visual Studio 2005
• T-SQL
• PL-SQL
• Crystal Reports
• ODBC
• MS Office
• Windows NT/ 2000 Server/ XP.

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

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

Responsibilities:

• Reviewed and analyzed business needs and developed Technical Specifications based on interaction wif Managers and Development Teams.
• Migrated historical financial data from Teradata and SQL Server to analyze cost model.
• Designed and developed the ETL platform using SSIS for moving the raw data 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 halp increase revenue, upsell, decrease churn.
• Experience of analyzing data, and interpreting financial cost models.
• Performed cost analysis and developing financial models for mortgage project.
• Managed more than 8 million financial transactions of clients for cost analysis Per Month.
• 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
• Involved in creating C# scripts using script task in SSIS.
• Created SSIS package to load data from XML Files to SQL Server by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension
• Proficiently worked wif various Teradata utilities like Bteq, Mload, Tpump, Fexp, OleLoad.
• Imported and exported data from text files, saved queries, or databases, used automatic outlining, inserted subtotals, created advanced filters, and used database functions using Excel.
• Created pivot tables and charts using worksheet data and external resources, modified pivot tables, sorted items and group data, and refreshed and formatted pivot tables in Excel.
• 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 wif Report authoring, Report management, Report delivery and security.
• Delivered task using Agile Scrum methodology and worked on backlog grooming, release and sprint planning, daily standups, impediment removal.
• Designed and developed database objects like Batch Scripts, Stored Procedures, Triggers, Views, Cursors, Indexes and User Defined Functions consumed at 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 TEMPeffective.
• 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,C#, XML,MySQL, MS office, Excel, PowerPoint.

Confidential, Charlotte, NC

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 and involved in creating C# scripts using script task in SSIS.
• 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 at 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, MySQL, MS office, Excel, PowerPoint,XML,Visual Intercept Enterprise Edition, Oracle 10g, VB.Net,C#,VSS 2005, Erwin v7.3, Windows NT/2003, Microsoft .NET framework 3.5.

Confidential

SQL Developer/SSIS/SSRS Developer

Responsibilities:

• Responsible for Conceptual, logical and physical design wif 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/XML, SQL Server 2005, instances, Oracle Databases and to load into staging and tan 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 at chat sessions and interviews.
• Adept at 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,SAP Tools, Microsoft Visual studio 2005,XML,Windows server 2003.