SUMMARY

• Over 6 years of strong experience in the IT industry as a SQL BI Developer with sound business analysis and data analysis skills.
• Experience in all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Extensive experience in MS SQL Server 2005/2008 R2/2012 along with Business Intelligence Tools (SSIS, SSRS).
• Performed Key Role in Logical and Physical Database design and development.
• Highly experience of Normalization/De - Normalization of database tables and building Referential Integrity for the (RDMS).
• Highly proficient in the use of T-SQL for developing Stored Procedures, Triggers, Tables, User Defined Functions, Views, Sub Queries, Relational Database Models, Data Integrity and SQL Joins.
• Experienced in Performance Tuning and Optimization of Stored Procedures and Queries.
• Highly experienced in designing, deploying and scheduling complex SSIS Packages in SQL Server 2008 R2 and 2012.
• Highly experience in Error handling, Package Configuration and Event Handling of SSIS package
• Highly experience on scheduling and managing automating tool SQL Server Agent, Control-M.
• Exposure working with web development tools such as ColdFusion, SharePoint, and Asp.Net.
• Highly experience 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.
• Experience in creating Monthly and Quarterly reports.
• Good in Collecting, Analyzing and Interpreting Data in an organized way. Versatile in working as an individual and also as part of a team.
• Proactive team player with demonstrated problem solving and analytical reasoning abilities with excellent written and oral communication

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, Scala, Python

SQL Server Tools: SQL Profiler, Performance Monitor, Database Tuning Wizard, SQL Server Agent, Extended Events

Databases: SQL Server 2005/2008R2/2012/2016, MS Access, Oracle, DB2, Teradata, MySQL

BI Tools: SSRS, SSIS

Web Technologies: HTML,XML, Visual Studio

Scheduling Tools: Control-M,SQL Server Agent

Version Control: SVN,TFS,Bitbucket

PROFESSIONAL EXPERIENCE

Confidential, Carrolton, Texas

Senior SQL Developer

Responsibilities:

• Worked harmoniously in a cross-functional team comprised of Managers, Lead, Business Analysts, Systems Design Group, Solution Architect, and other Developers to ensure the delivery of solutions as planned.
• Extensively wrote complex Stored Procedures, Functions, View per business requirements and per ad-hoc requests by business users.
• Identified and optimized the long running stored procedures by analyzing the EXECUTION PLAN, Extended Events, DMV, and SQL Profiler etc.
• Designed and Deployed SSIS packages to load data from OLTP environment to Data Warehouses.
• Used Lookup and Fuzzy Grouping transformations for improving the data quality of the existing data as well as new data while loading into Enterprise Data Warehouse.
• Documented Technical Design for ETL processes and databases, and ensured optimal technologies are utilized as well as built and implemented according to plan.
• Handled error on SSIS Packages by redirecting rows to an Error Log table.
• Worked closely with Business Analysts to ensure programming code meet the business requirements.
• Participated in investigation and creation of Data Landing / Data Retrieval from multiple data sources based on analysis and design requirements.
• Reviewed the codes and corrected inefficient code and guided with correct direction.
• Wrote Technical Documents for production failure jobs to handle it efficiently and uploaded in the SharePoint.
• Good experience to maintain the codes in Bitbucket through Source Tree.
• Handled ONCALL efficiently and fixed the production failure jobs immediately and allowed the jobs to flow smoothly.
• Researched PRODUCTION failure jobs efficiently and provided the solution for the long-term fix.
• Proactively analyzed the existing file process end to end and generated the new idea and approach for the long term and reliable solution.

Environment: MSSQLServer2016, TSQL, SSRS, SSIS, SEQ, C#, Azure, MongoDB

Confidential, Dallas, Texas

Data Analyst

Responsibilities:

• Facilitated meeting with business and technical teams to understand the requirements, discussed the acceptance criteria of the stories, attached the sample data sheet in JIRA, and discussed data validation methodology and prioritized the stories in the backlog.
• Extensively wrote Stored Procedures according to architecture diagrams and data models provided by solution architect.
• Performed data and business analysis and delivered consumable reports to identify trends, potential issues, findings and actionable recommendations.
• Worked with Internal Customers, Product Management, Finance and Marketing team to gather requirements for the development of reports and ensured the data accuracy in SSRS reports.
• Created Monthly, Quarterly business reports and presented the finding to the Product Owner and VP.
• Diagnosed the long running codes into the legacy system and resolved the data performance issue.
• Worked on Hadoop Environment for extracting the data from various source systems such as MS-SQL, Oracle, Teradata, SharePoint etc. and load into EDH environment.
• Used V-LookUP, Power Query, IF Else, Datevalue, Timevalue, MID, Amortization etc functions in Excel for analyzing the data and data validation.
• Experienced in unit testing, fixing code defect, modifying stored procedure and debugging as per requirement.
• Reviewed the code in the Legacy System, developed the technical design documentation and prepared it as a part of new stories for upcoming sprint.
• Wrote scripts, metadata structures of source and target objects in MYSQL database as a part of initial set up to load data into EDH environment.
• Wrote Linux Script to process the file by analyzing the error into files like newline, special character etc.
• Created HQL for HIVE tables and loaded the data in HIVE by Python Integrated Framework.
• Joined multiple tables in the HIVE and incorporated the business logic as a part of data modeling stories and ingested into Optimus Framework which will be accessed by the end users for reporting purpose.
• Set up the control M Job Sequences and scheduled the jobs based upon the dependencies.
• Handled efficiently OnCall Production jobs failure.
• Maintained the version control by deploying the source code into Bitbucket through TortoiseGit.
• Built and deployed the SSIS packages per requirement and deployed in Production Environment.

Environment: MSSQLServer2012,TSQL,SSRS,SSIS,HDFS,Sqoop,Hive,Spark,Python,Oracle,Teradata,DB2,Toad,Control-M,Eclipse,Oozie, WinSCP, Jenkins, Joules, Linux, MySQL, SharePoint, SharePoint List etc.

Confidential, Dallas, Texas

Data Engineer

Responsibilities:

• Extensively developed SQL Programs and Stored Procedures as required for the ETL processes and Data Integration activities.
• Built and Maintained SQL Scripts, Indexes, and complex queries for the data analysis.
• Worked with Application Team, extensively used SELECT queries to populate the data from the application tables and provided to the end users after deeply analysis and validation.
• Optimized the long running Stored Procedures by rewriting the script, creating temp table and indexes, recompiling the stored procedure, updating the statistics and make the process simpler and faster.
• Extensively used BCP to Import and Export the flat files for Internal and External Vendors.
• Developed, Automated and Maintained the Control-M jobs which have involved the variety of data development tools to move the data.
• Created SSIS Event Handler in Event Handler tab through Send Mail Task to notify ETL group during error event.
• Worked on Error Handle on SSIS by redirecting the error records into separate table and finally loaded after fixing them.
• Successfully processed the files through Control-M jobs once the Client dropped it via-Download from FTP, Decrypt, Unzip, and Load to Stage, stage to Target, Delete the files from source and finally Encrypted and Archived it.
• Extensively Developed, Tested and Automated the Batch Scripts for the Data Integration activities.
• Supported On-Call Team by deeply analyzing the production failure jobs and supported the offshore team to handle the production issues.
• Experienced in writing the Technical Documentation for the complex process as requested by end users.
• Highly experienced in working on TFS for maintaining the effective history of database objects.
• Extensively analyzed the acceptance criteria of the user stories created in the Rally and provided the necessary guidance and instructions per needed.
• Good knowledge and experienced with Informatica to load the data from source to target.

Environment: MS SQL Server 2012,SSIS,SSRS,T-SQL, Control-M, Informatica, Windows 2007, Windows 8, Windows Server 2003, MS Access, MS Excel.

Confidential, Fort Worth, Texas

SQL Developer

Responsibilities:

• Wrote complex queries as per requirement to implement the business rule.
• Planned, Designed, and Implemented application database code objects, such as Stored Procedures, Functions and Views.
• Created complex SQL scripts using Joins, Sub-Queries, Recurrsive CTE and Derived Table.
• Worked on Functional design, System analysis, gathering of user requirements and maintaining good documentation.
• Worked on Normalization and De-Normalization of OLTP and OLAP environment.
• Worked with DBA to identify long running Stored Procedures using tools like SQL Profiler, Execution Plan, and DMV.
• Created SQL Server package configuration to make the package dynamic.
• Developed the SSIS package to loop the folders having multiple flat files. Processed and Archived the files using File System Task
• Interacted with Business Analyst, Subject Matter Experts, and Stakeholders to understand their needs and provided the solutions by writing SQL Objects.
• Translated business requirements into reports by writing Views, Stored Procedures etc.
• Used Script Task on multiple purposes:
• To check whether the source files exist on the source path or not. To append the current date and time before and after file processing. To rename the source files after successfully loaded into tables. To send the error file to the error path by appending the current date-time stamp in the source file. To send an empty file in the source path by appending current date-time stamp after the package ran successfully.
• Deployed SSIS package on SQL Server 2012 and created jobs in SQL Server Agent.
• Created ETL log table to capture the different SSIS Events as a part of event and error handler

Environment: MS SQL Server 2008R2/2012, SSIS, SSRS,T-SQL,SQL Profiler, Windows 2007, Windows Server 2003, Visual Studio 2010, Report Builder 3.0, MS Access, MS Excel.

Confidential, Dallas, Texas

SQL Server/BI Developer

Responsibilities:

• Created complex Stored Procedures, Triggers, Indexes, Function and views and other SQL joins for implementing the business rules and transformations
• Created and maintained logins, roles and permissions on the SQL instances and databases and provided required privileges.
• Optimized long running stored procedures, sql queries using SQL Profiler, Execution Plan, DMV and Optimized indexes to improve query performance.
• Resolved issues with Index Fragmentation.
• Identified blocking, locking and deadlock queries through SQL Profiler and DMV.
• Created SSIS packages to export and import data from csv files, text files and excel spreadsheets. Used Transformation according to business requirement.
• Used Third Party Tool (COZYROCH) for downloading and unzipping zip files from FTP Server.
• Scheduled Daily and weekly Jobs using SQL Server Agent and sending alerts using Send Mail Task.
• Deployed SSIS Packages from development server to production server.
• Worked on SSIS Package Security, Package Configuration and Check Point.
• Upgraded of SSIS Package from .
• Generated Parameterized/Drilldown, Drill Through, Sub Reports, Linked reports using SSRS and deployed reports to Reporting Server and Report Manager.

Environment: MS SQL Server 2008R2/2012, SSIS, SSRS, T-SQL,SQL Profiler, Windows 2007, Windows Server 2003, Visual Studio 2010, Report Builder 3.0, MS Access, MS Excel.

Confidential, Beaverton, Oregon

SQL Server/BI Developer

Responsibilities:

• Designed, reviewed and created objects like Table, View, Indexes, Stored Procedure, and Function according to the business requirement.
• Tuned Stored Procedures by doing Index Defragmentation, rewriting SQL scripts, managing indexes on tables.
• Built Table Valued Function, Scalar Valued Function to suffice the needs for business rules and for the implementation in stored procedures.
• Created Master and Child packages, Package Configurations and Logging tables.
• Analyzed the Business Requirement Document(BRD)to design a conceptual model to be implemented with T-SQL and SSIS.
• Created Tabular Reports, Matrix Reports, List & Chart Reports, Parameterized Reports, Sub Reports, Ad-hoc Reports, Drill Down Reports as well as Interactive Reports according to business requirements
• Deployed reports to the Reporting Server and Report Manager and automate the reports using SQL Server Agent and scheduled the reports according to requirement.
• Tuned reports and created data driven subscriptions for different users in Report Manager.
• Involved in all stages of development process - high-level design, implementation, testing, deployment and support of products adhering to company's SDLC

Environment: MS SQL Server 2008R2/2012,SSIS,T-SQL,Teradata (EDW), Windows XP, Windows Server, Visual Studio 2010, Report Builder 3.0, MS Access, MS Excel.