SUMMARY:

• Over 8 years of Experience in Oracle SQL, T - SQL, Data Warehousing and Business Intelligence applications (ThoughtSpot, Power BI) and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS).
• Experience in data analysis, design and development of databases for business applications in a client/server and data warehouse environments in SQL Server 2016/2014/2012/2008.
• Knowledge in all areas of SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, triggers, relational database models, data dictionaries, and data integrity.
• Expertise in Extract Transform Load (ETL): Informatica 8.0, SQL Server Integration Services (2008,2012,2016,2017)
• Expert in implementing Database Normalization, designing and creating Indexes, Develop Queries and T-SQL Scripts in MS SQL.
• Skilled in Query Optimization, Performance tuning, and providing database security by creating users, permissions, and role-based access to data.
• Adept at using Microsoft Visual Studio and deployment of ISPAC & DACPAC
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.
• Extensive experience in Alteryx 10 for Spatial-Analytics and demographic reports by using coordinates utilizing Experian and D&B Data sources.
• Involved in complete SDLC, which includes requirement gathering, analysis, design, development and Implementation.
• Certified in Safe Lean Scaled Agile Practitioner in Big Data Hadoop

TECHNICAL SKILLS:

• Programming Languages: SQL, T - SQL, DAX, Hive, Pig
• Databases: SQL Server 2016/2014/2012/ 2008, Oracle 11g, Oracle 12c, AS400
• Database Tools: SQL Server Management Studio, Alteryx, Informatica, Business Intelligence Development Studio, T-SQL, ETL, Oracle SQL DeveloperReporting Tools: SQL Server Reporting Services, Power BI, Tableau, ThoughtSpot
• Application Packages: SSIS, Informatica, Sagent, Alteryx.
• Operating System: Windows 2008R2 Server,Windows Server 2012,Windows Server 2016,2017

PROFESSIONAL EXPERIENCE

Confidential, Fort Worth, TX

Sr Data Engineer/Analyst & Lead Safe Agile Practitioner

Responsibilities:

• Involved in analysis, design and development of project to consume transactional data, consolidate into data warehouse and creating reports and dashboards, writing Stored Procedures for creating datasets for Reports and dashboards.
• Gather business requirements, defined and designed the data sources, data flows, data quality analysis, worked in conjunction with the data warehouse architect on the development of logical data models.
• Create SSIS packages to load the data from source to the tables.
• Created store procedures to transform data and load into the tables.
• Create stored procedures and functions to transform data and load into the tables.
• As a Database ETL SSIS developer I have certain responsibilities as following which are required for Project task/activities on daily basis.
• Work closely with the business leads and product owners across Financial Planning, Customer Insight (Commercial), Customer Services and understanding their reporting requirements, analyzing customer data and implementing the best solutions that meet their business requirements and technical challenges,
• Conduct Agile scrum meetings.
• As per the new requirements, converting functional requirement into Technical solutions.
• Revising existing systems and procedures to correct deficiencies and maintain more effective data handling, conversion, and input/output requirements
• Create and maintain SSIS packages.
• Involved in analyzing, designing, building & testing of SSIS packages to move the data downstream applications.
• Fine-tuned existing queries to improve performance utilizing SQL Profiler and Execution Plans.
• Performance tuning of Informatica jobs and SQL periodically to improve the load performance
• Performing a techno functional role acting as liaison between Business & Technology partners.
• Understanding user requirements and providing work estimates on planned releases and projects.
• Requirement scrutinizing and maintaining traceability metric. Resolving issues reported by clients.
• Post-development organize with Team and the customer for QA, UAT and Prod deployments
• Holds regular status meetings with the team. Perform code reviews and mentor team members.
• Manage communication regarding solution design/delivery with client technical stakeholders.
• Deploy the code changes in lower environments through Continuous Delivery (DevOps).

Environment: MS SQL 2016, VSTS 2017, SSIS, SQL, T-SQL, ThoughtSpot, Power BI, DB Visualizer, Data Grip, SVN

Confidential, Fort Worth, TX

Data Warehouse Analyst

Responsibilities:

• Download, clean, validate and load data received from different clients.
• Perform counts on prospects, customers based on different geographical locations as requested by clients.
• Provide customer, prospect names and other details from the database: Experian, DNB and other data sources.
• Extract data from the database and warehouse based on different criteria requested by clients.
• Process and aggregate data using Hadoop, Hive and Pig.
• Quality-check other team members work for delivery efficiency.
• Point of contact to client’s internal data team to receive initial data transfer from client.
• Hands on alteryx tool for data analytics (ETL, cleansing, reporting and scheduling).
• Setting up automation via sagent automation.
• Attend meetings to interact with project management for new assignments received from clients.
• Document the standard and workflow processes for convenience of other team members.
• Conduct data mining, maintaining data cleansing and updating data warehouses.
• Derive demographics from spatial objects (TAB files) produced by Spatial Analytics (GIS).
• Run different SQL queries to inquire about competition and opportunities nationwide.
• Utilizing SSIS and SSRS for integration and reporting.
• Quality-check models built by predictive analytics.
• Communicate with project management to address client’s needs and specs.
• Track the progress of projects and tasks through SalesForce and Clarizen.
• Helped the department save 25% of its budget migrating from Oracle to Microsoft SQL Server.

Environment: MS SQL 2008/2012/2014 , SSIS, Tableau, Alteryx, T-SQL, MS Excel, Sagent, ETL, Visual Studio and Accuzip

Confidential

Jr. ETL (Informatica)/Data Analyst

Responsibilities:

• Source system evaluation, standardizing received data format, understanding business/data transformation rules, data transformation through mapping development, validation and testing of mappings.
• Extract data from flat files, Oracle database and transforming upon business needs and loading to the target.
• Create various mappings like update strategy, look up, sequence generator, expression, aggregator and tested the mappings for data verification in designer.
• Implement slowly changing dimension methodology for accessing the full history of accounts and transaction information.
• Run various performance tuning techniques like optimized query performance, session performance, reliability, partitioning.
• Extensively use Informatica tools - Informatica Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Design and develop several scripts for extracting, transformation and loading of data using Informatica.
• Successfully move the sessions and batches from the development to production environment.

Environment: Informatica Designer, Workflow Manager, Workflow Monitor and Repository Manager, Oracle 11g