­­­­­­

SUMMARY:

• A Over 9+ 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), Teradata, Oracle Sql in Financial, Banking and Telecommunications industries.
• EE Good Business and System analysis skills to understand the requirements and customize client applications.
• MS SQL Server Developer 2012/2008R2/2008 with 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 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 ERWIN.
• Experience in Tableau Desktop, Tableau Server in various versions of Tableau 6/8/9.
• 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.
• Worked on SSAS ( SQL Server Analysis Services) to build analytical cubes on Multi-Dimensional and Tabular Models and exposed data for Ad-Hoc Reporting for the end User.
• 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
• 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).
• Databases: Very good experience on Teradata,Oracle and SQL server strong experience on Teradata utilities (Multiload, Fastload, FastExport, Tpump, BTEQ)
• Good working Experience on Oracle SQL Developer.
• Worked as team lead to design and develop the code and coordinated with off-shore team on deliverables
• Good experience on performance tuning of the complex SQL queries
• 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.
• Knowledge of SAP System and tools.

EMPLOYMENT HISTORY:

Confidential, Irving,TX

Teradata and Hadoop ETL Developer

Responsibilities:

• Gathering Business requirements from the project stakeholders
• Worked with the Project Manager and Business Analyst to understand the business requirement and involved in planning, defining and designing data based on business requirements
• Analyzing the application and creating the complex views by joining the source views
• Creating mapping documents.
• Designing and developing the SSIS batches for loading data from OLTP system, DSR (Staging Database) to Data Warehouse.
• Data Analytics, ETL Load and Reports Preparation
• Data modeling using ERWIN
• Develop Data architecture for Teradata/Big Data platform/sql server/Oracle sql
• Working on Adhoc report requests from the business Users
• Experience in Used excel sheet, flat files, CSV files to generated Tableau combination reports.
• Process Optimization and Tuning the queries if they are not performance compliant
• Designing and Developing data modules that convert underlying raw data to more readily usable formats for reporting
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and representatives for various business needs using Subscription in SQL Server Reporting Services (SSRS)
• Performing data deep dives to pinpoint Problems
• Writing SQL scripts to test the mappings and Developing Traceability Matrix of Business Requirements mapped to Test Scripts
• Unit Testing of the code and production turnover
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues
• Create documents for all Store Procedures, SSIS packages and SSRS Reports have been developed
• Coding using Teradata, T-SQL, SQL,Oracle,Hive QL
• Creation of the Cubes using Microsoft SQL server Analysis services
• Creation of Pivot tables using Microsoft Excel for better understanding of data
• Metrics generation and presentation using the reporting tools like Tableau, SSRS
• Preparing required project documentation and tracking and reporting regularly on the status of projects to all project stakeholders
• Working with Business Analysts and other business teams to get the required data to build the semantic Views
• Working on the Migration from Teradata to Hadoop/HDFS database
• Creation of Hive tables, Loading the data into those tables and Developing Hive queries
• Loading the data from different Source systems using Etl
• Loading the data to Hadoop/HDFS environment to build analytical dashboards
• Working on job failures and resolving the job failures with in the SLA
• Creation job work flows using Microsoft SQL Server Management Studio

Environment: Teradata SQL, MS SQL, Oracle sql, Hive ql, Unix/Linux Shell Scripting,HDFS,Teradata SQL Assistant, Microsoft Excel, Microsoft SQL Server Management Studio, Microsoft SQL Server,Analysis Services(Cubes),Integration Services & Reporting Services, Erwin, Hadoop and Cloud System, HDFS, Oracle Sql Developer,Tableau, SSRS

Confidential, Plano,TX

MS SQL Server/Teradata /SSIS/SSRS/ Tableau /DBA

Responsibilities:

• Reviewed and analyzed business needs and developed Technical Specifications based on interaction with 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 help increase revenue, upsell, decrease churn.
• 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
• Proficiently worked with 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 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, 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.
• 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.
• Used Teradata utilities fastload, multiload, tpump to 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, Visual Intercept Enterprise Edition, Oracle 10g, VB.Net, VSS 2005, Erwin v7.3, Windows NT/2003, Microsoft .NET framework 3.5.

Confidential

Database Administrator

Responsibilities:

• Involved in designing the database to cover all the Business Logic modules.
• Responsible for creation of database stored procedures for Windows Forms using MS SQL Server and T-SQL.
• Actively played the role of documentation of all the implementations for purposes.
• Involved in creation of tables as per the requirements of the project for assigning authentication rules accordingly and storage of data.
• Actively involved in test scenarios preparation and came up with test scripts that covered all the modules of the project.
• Actively involved in Adding the Buttons and Assigning the products and to Design the Front look.
• Actively involved in Creating the Reports Weekly, Monthly.
• Actively involved in the Networking as well.
• Handling Ocims Application it is a Software Product used in the POS(Point of Sale) Machines that coordinated and integrates all the inherent activities involved in the management and running of the hotel. The software provides security, technology and functionality standards for managing electronic records and practice management information. OCIMS systems maintain the complete Data Information in SQL Database.
• As a team member I was involved in Database Administration and Testing.

Environment: Asp.net (Visual Studio2010),SQL Server, ADO.NET, WCF, LINQ, Crystal Reports, RDLC Reports, MS-DOS, UNIX, Windows 9x/NT/2000/XP/Vista/7/8

Confidential

SQL Developer & .Net Developer

Responsibilities:

• Interacted with business analyst team to understand the system requirements.
• Involved different phases of Software Development Life Cycle (SDLC) including Designing, Development, Implementation, and Testing.
• Developed Web Forms for this application using ASP.NET 3.5 and C# with Visual Studio.NET 2008 environment.
• Designed User Interfaces using CSS, Master Pages and JavaScript.
• Developed various screens for this portal using ASP.NET and C#.
• Developed various XML config files, methods in handlers for displaying controls names, error messages and some text messages.
• Developed class files for business process layer and data access layer.
• Extensively used data controls like data view controls and dropdown list controls for manipulating the data.
• Developed and Consumed Web Services for business process layer.
• Utilized Microsoft application blocks & practices for data access, configuration and for minimizing repeated code.
• Used ADO.NET namespaces and classes, and created data access components to access database.
• Wrote complex stored procedures and SQL queries using Sql Server for extracting, inserting and manipulating the data and display on Grid view controls and dropdown list boxes and User controls.
• Performed unit testing and system integration testing.
• As a team member I was involved in Development, Database and Testing.
• I was involved Production support and Maintenance for this application.

Environment: Windows XP, Visual Studio.NET 2008, ASP.NET 3.5, C#, ADO.NET, HTML, JavaScript, CSS, XML, IIS 6.0, Web Forms, Web Services, SOAP, Sql Server 2005, Web Services, and MS Visual Source Safe 6.0.