SUMMARY:

• A Over 10 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, postgre SQL in Financial, Banking and Telecommunications industries.
• EE Good Business and System analysis skills to understand teh 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 teh end User.
• Highly proficient in teh 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 teh OLTP to OLAP/EDW with teh 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
• 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 teh data, Defining Data Source and subtotals for teh 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 teh code and coordinated with off-shore team on deliverables
• Good experience on performance tuning of teh 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 TEMPeffective team member with excellent analytical, troubleshooting, and problem solving skills.

PROFESSIONAL EXPERIENCE:

Confidential, Irving,TX

SQL and Teradata Developer

Responsibilities:

• Gathering Business requirements from teh project stakeholders
• Worked with teh Project Manager and Business Analyst to understand teh business requirement and involved in planning, defining and designing data based on business requirements
• Analyzing teh application and creating teh complex views by joining teh source views
• Creating mapping documents.
• Designing and developing teh 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 teh business Users
• Experience in Used excel sheet, flat files, CSV files to generated Tableau combination reports.
• Process Optimization and Tuning teh 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 teh mappings and Developing Traceability Matrix of Business Requirements mapped to Test Scripts
• Unit Testing of teh 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 has been developed
• Coding using Teradata, T-SQL, SQL,Oracle,Hive QL
• Creation of teh Cubes using Microsoft SQL server Analysis services
• Creation of Pivot tables using Microsoft Excel for better understanding of data
• Metrics generation and presentation using teh reporting tools like Tableau, SSRS
• Preparing required project documentation and tracking and reporting regularly on teh status of projects to all project stakeholders
• Working with Business Analysts and other business teams to get teh required data to build teh semantic Views
• Working on teh Migration from Teradata to Hadoop/HDFS database
• Creation of Hive tables, Loading teh data into those tables and Developing Hive queries
• Loading teh data from different Source systems using Etl
• Loading teh data to Hadoop/HDFS environment to build analytical dashboards
• Working on job failures and resolving teh job failures with in teh SLA
• Creation job work flows using Microsoft SQL Server Management Studio

Environment: Teradata SQL, MS SQL,KSQL, 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 teh ETL platform using SSIS for moving teh raw data log files from windows landing pad to HDFS, separated teh logs by module, parsed teh files and created module based hive tables.
• Worked on number of data migration project from Teradata to SQL and SQL to Teradata based on teh 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.
• 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 teh 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 teh viewership of networks across various and send lead lead-list to teh 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 teh version control of teh items being worked by various members in teh 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 teh files on daily basis like renaming teh file, extracting data from teh 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 teh project cost TEMPeffective.
• Managed and mentored offshore resources to get work done from offsite while taking requirements from teh 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, India

SQL Server /SSIS/SSRS Developer

Description:

Polymath is a global software solutions and SAP services provider. We are a business and technology group specializing in industry specific solutions and strategic outsourcing currently Polymath is focusing on Medical transcription services and diverted SAP vertical to our another company INTELYST CONSULTING INDIA PRIVATE LIMITED.Teh aim of teh project was to design and develop Data warehouse and migrate teh data from different sources into teh databases using SSIS and perform calculation using T-SQL and generating various simple and dynamic reports using SSRS.

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 teh 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 teh database and other applications in most efficient manner.
• Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on teh 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 teh development of Dashboard reports for teh Key Performance Indicators for teh top management using Tableue.
• Developed Unit Test Plans for SSIS packages for checking teh functionality of each component.
• Modified teh existing SSIS packages to meet teh changes specified by teh users.
• Scheduled Jobs for executing teh stored SSIS packages which were developed to update teh 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 teh monthly/weekly/daily reports to run automatically onto teh Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created various database objects like stored procedures, functions, tables, views.
• Involved in teh design and development of web forms for teh application using ASP.Net to take care teh cosmetic works of teh reports deployed on teh server.
• Created and published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Configured teh 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 teh database to cover all teh Business Logic modules.
• Responsible for creation of database stored procedures for Windows Forms using MS SQL Server and T-SQL.
• Actively played teh role of documentation of all teh implementations for purposes.
• Involved in creation of tables as per teh requirements of teh 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 teh modules of teh project.
• Actively involved in Adding teh Buttons and Assigning teh products and to Design teh Front look.
• Actively involved in Creating teh Reports Weekly, Monthly.
• Actively involved in teh Networking as well.
• Handling Ocims Application it is a Software Product used in teh POS(Point of Sale) Machines that coordinated and integrates all teh inherent activities involved in teh management and running of teh hotel. Teh software provides security, technology and functionality standards for managing electronic records and practice management information. OCIMS systems maintain teh 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 teh 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 teh 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 teh 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.