SUMMARY

• Innovative, competent and results driven IT professional offering advanced understanding of software development cycle (SDLC) including requirement gathering, data analysis, design, development, implementation, and testing and deployment coupled wif 5+ years of experience as a Microsoft Business Intelligence Developer.
• Recognized throughout career for demonstrating teh ability to organize and complete complex projects, delegate assignments to staff as well as meet deadlines in high - volume workload environments.
• Vastly adept at building strong relationships and implementing strategies to improve processes and drive overall performance. My overall goal is to expand my career brand by obtaining a position as a Data Engineer, ETL Engineer, Data warehouse developer or Cloud Data Engineer where my expertise can be utilized to bring value.

AREAS OF EXPERTISE

• Data Modeling
• Database Warehousing
• Data Mining, Azure
• Programming Languages
• Operations Management
• Strategic Planning/Execution
• Resource Utilization
• Performance Measurement
• Process Improvement Initiative
• Operating Systems
• Data Entry and Analysis
• Technical Research and Analysis
• Troubleshooting: Software and Hardware Issues

• Strong Decision Making Abilities
• Collaborative Teamwork
• Emotional Intelligence
• Business Intelligence
• Time Management

• Analytical and Critical Thinking
• Exceptional Communication Skills
• Accountability
• Analytical and Critical Thinking
• High Attention to Detail

PROFESSIONAL EXPERIENCE

Confidential, Texas

Senior Data Engineer

Responsibilities:

• Designing and developing teh staging databases as well as loading data from heterogeneous sources to staging and from staging to teh target tables and applying different transformations in-between.
• Held accountable for designing SSIS packages using several transformations to perform data profiling, data cleansing and data transformation.
• Good noledge in Azure technologies- Azure Data Lake, Azure Data Factory, HD Insights.
• Analyzing teh data to implement incremental/delta load using a merge statement.
• Extracting data from various source files like Excel, XML, and Flat files and loaded teh data to a SQL Server DB target table.
• Created Sqoop scripts to import/export user profile data from RDBMS (DB2) to Azure Data lake.
• Utilizing SSIS transformations such as lookup, derived column, data conversions, conditional split, SQL task, script task, send mail task etc.
• Created scripts in Python which integrated wif Amazon API to control instance operations.
• Held accountable for creating dashboards, Tabular, Matrix reports (crosstab or pivot), Charts and graphs as per customer requirement using SSRS.
• Plan, build and configure network infrastructure wifin VPC wif public and private subnets, configure routing tables, security group and internet gateway.
• Create low latency website using S3, CloudFront, and Route53
• Wrote Lambda functions that automatically snapshots instances to be backed up in secondary regions for disaster.
• Scheduling CloudWatch events to trigger lambda functions at a specific time to run CloudFormation templates in S3 Bucket.

ETL Engineer

Confidential

Responsibilities:

• Achieved goals by actively working on all processes related to teh development, implementation, administration, and support of teh SSIS ETL.
• Held accountable for being involved in business analysis and technical design sessions wif business and technical staff to develop requirements document and ETL design specifications.
• Designed, Implemented, and maintained Database Schema, Entity relationship diagrams using Visio, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults, and complex SQL statement.
• Used SSIS to create ETL packages to validate, extract, transform and load data to teh data warehouse database from various sources like Text Files, XML, Excel, and Access DB.
• Implemented Data Lake in Azure Blob Storage, Azure Data Lake, Azure Analytics, Data bricks Data load to Azure SQL Data warehouse using Poly base, Azure Data Factory.
• Created complex SSIS packages wif error handling capabilities using various data flow task transformations (conditional split, data conversion, look up, merge), tasks (execute SQL, data flow, script, send mail tasks) and containers (sequence container, for loop, for each loop container) etc.
• Analyzed teh data to implement incremental load using merge statement and overseen teh migration of large amounts of data from OLTP to OLAP using SSIS ETL tool.

Confidential, Texas

Data Engineer

Responsibilities:

• Achieved goals as a Data Engineer by overseeing database development as well as gathering, specification and data mapping document for development of SSIS ETL projects.
• Implemented process to configure SQL DB mail to send automatic e-mails when SSIS packages fail or succeeded.
• Held accountable for performing efficient tuning of SQL source for data load as well as utilizing stored procedure for improved query performance as necessary.
• Served as a collaborative team member wifin both project management and software development life cycles (SDLC) including analysis of business functions, testing and documentation as required by end-users.
• Utilized SSIS to create ETL packages (.dtsx files) that validated, extracted, transformed and loaded data to data warehouse database and processed SSAS cubes that stored teh data in aggregated format for analysis.
• Recognized for designing a parameter driven report utilizing Microsoft T-SQL, SSRS and Tableau, as well as communicated project status wif management.
• Demonstrated core leadership abilities by assisting team in redesigning teh existing reporting process to develop and distribute financial reports to top management and various stakeholders more efficiently.

TECHNICAL SKILLS

• Recognized for efficiency in creating SQL Server database objects such as tables, stored procedures, indexes, views, constraints, user defined functions etc.
• Demonstrates a solid understanding referential integrity between primary and foreign keys and applies extensive noledge in SQL query optimization and performance tuning tools like SQL profiler, Data base engine tuning advisor.
• Demonstrates extensive skill in using SQL Server Data Tools (SSDT) to create SSIS ETL solutions.
• Skilled in SSIS ETL migration from different sources such as files (Flat file, XML, Excel etc.) and databases (Oracle, SQL Server, MySQL etc.) to a target file or database destination.
• Extensive experience in Error handling, precedent constraints, break point and check points.
• Great understanding of teh data warehousing concept (OLTP and OLAP respectively) using dimension model.
• Extensive experience in creating various SSRS report using visual studio (SSDT), troubleshooting slow running reports, creating table and matrix reports as well as report dashboards.
• Recognized for being highly skilled in creating drill down and drill through reports, parameterized and sub reports as well as ability to deploy reports to teh report server and give security permission to teh end users.
• Experienced in logical and physical dimensional modeling, ER modeling, star / snowflake schemas, fact and dimensional tables and operational data store (ODS).
• Developed multi-dimensional objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).