PROFESSIONAL SUMMARY:

• Over 5.3 + years of extensive experience in database design, development and administration with MS SQL Server versions 2014/2012/2008 /2008 R2 using SSIS, SSAS, SSRS (BI Tools).
• Good Business and System analysis skills to understand the requirements and customize client applications.
• MS SQL Server Developer 2012/2008R2/2008 with 5+ years of IT experience in various Industry verticals like telecommunication, Finance, and Service. Maintained positive communications and working relationships at all business levels.
• Experience conversion of SAS reporting to SQL SSIS/SSRS solutions
• 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 and also Involved in creating C# scripts using script task in SSIS
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.
• Experienced in Installing, Upgrading and Configuring Microsoft SQL Server 2008/2005/2000 .
• Experience in analytical Database Design and Data Modeling skills using MS Visio and Confidential .
• Experience in Tableau Desktop, Tableau Server in various versions of Tableau 6/8/9.
• 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
• Involved in data load using PL/SQL and SQL Loader and jobs calling UNIX scripts to download and manipulate files.
• 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.
• Created 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 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
• Confidential
• Power designer
• DB2 SQL syntax
• MySQL
• MS office
• Excel
• PowerPoint .
• MS-Access 2000
• C
• C++
• VB 6.0
• Developer 2000
• Confidential 7.3/4.2/4.2/4.0
• 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, Los Angeles, CA

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.
• Developed MapReduce programs to parse the raw data, populate staging tables and store the refined data in partitioned tables in the EDW.
• 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.
• Migrated historical Customer data and 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.
• Extensively used SAS procedures like PROC SQL, PROC SORT, PROC PRINT, PROC MEANS, PROC DATASETS, PROC CONTENTS, PROC FREQ, PROC FORMAT, PROC REPORT, PROC TABULATE, PROC COPY and PROC EXPORT.
• Experience in Used excel sheet, flat files, CSV files to generated Tableau combination reports.
• Created analytical reports and dashboards using filters, parameters, sets, bins and implemented visualizations with complex calculations to manipulate the data.
• 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
• 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 developed Fast Load and MLoad scripts 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) using SQL Server Analysis Services (SSAS).
• Worked on SQL Server Reporting Services with 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.
• Writing Unix Shell Scripts to process the files on daily basis like renaming the file, extracting data from the file.
• 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,C#, XML,MySQL, MS office, Excel, PowerPoint .

Confidential

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.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• 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 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.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Used Teradata utilities fastload, multiload, tpump to load data.
• 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, Visual Intercept Enterprise Edition, Oracle 10g, VB.Net, VSS 2005, Confidential v7.3, Windows NT/2003, Microsoft .NET framework 3.5.

Confidential

SQL Developer/SSIS/SSRS/DBA

Responsibilities:

• Responsible for Conceptual, logical and physical design with a significant effort towards application using Confidential .
• Perform weekly database checkup, shrink database according to instructions, and document weekly database activities.
• Implemented High Availability in SQL 2012 by configuring Always On Availability groups across Windows Server Failover Clustering using Failover Clustering Instances
• Worked extensively on database administration, storage maintenance, software upgrade, installation, replication monitoring, backup &recovery planning, partition tables, indexes, and performance tuning.
• 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.
• 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.
• 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 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 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.