CAREER OBJECTIVES:

• Microsoft SQL Server database T - SQL developer
• Microsoft BI Developer (SSRS/SSIS)

SUMMARY:

• One real Microsoft SQL Server developer who has about six years of focused experiences in MS SQL Server/BI development area in fields like financial, health care and information security.
• Extensive experiences in SQL Server database analysis, modeling, development, implementation, trouble shooting and quality management. Have solid experiences in SQL and T - SQL coding, debugging, agile / scrum software development methodologies. Have impeccable communication and interpersonal skills and an exceptional team player.
• Over six years of working experiences in database Design, Coding, Testing and Operation of various Microsoft Data Warehouse and Business Intelligence Projects.
• Very strong in the development for Microsoft SQL Server (SQL Server 2008/2008R2/2012/2014 development skills with emphasis on development of Transact-SQL).
• In-depth knowledge of complex T-SQL. Power user of advanced SQL queries with multi-table joins, group functions, sub-queries, set operations and functions.
• Expert in creating indexes, views, complex triggers, effective functions and stored procedures to facilitate efficient data manipulation and data consistency.
• Solid knowledge and experiences on SQL performance tuning using Execution Plan, SQL Profiler and Extended Events.
• Solid first-hand experiences with Microsoft SQL Server Data modeling and Database Logical /physical Design. Strong sense of information system security.
• Strong Experience with Online Analytical Processing tools (OLAP), designing Data Marts and Data Warehouse using Star Schema and Snowflake Schema in implementing Decision Support Systems, fact and dimension tables modeling of data at all the three levels: view, logical and physical.
• Good understanding of Data Integration patterns, ETL Performance, Parallelism Strategies and Debugging/Troubleshooting performance problems. Advanced SSIS concepts of Data Warehouse package design for Incremental load, Slowly Changing Dimensions(SCD).
• Two years experienced with reporting tools like SSRS, Tableau; proficient in manipulating data and generating neat reports using Excel.
• One year experienced using python language to make data virtualization and data model.
• Hands on experience of creating ETL package using SSIS. Understanding of Source to Target Mapping
• Hands on experience of C# for debugging and application development.
• Knowledge and experience of designing HR data model and maintaining the database performance.
• Distinguished in developing documentation, departmental technical procedures, diagrams and user guides.
• Solid knowledge and experiences of Agile software development life cycle and project manage methodology.
• Knowledge and experience of Control-M.
• Self-driven with ability to take initiatives and meet deadlines in a fast-paced changing environment; strong analytic and communication skills with the enthusiasm to learn new technologies.
• Excellent English writing, verbal and communication skills. Strong team player and be able to work alone. Highly self-motivated and able to adapt and learn new technologies quickly.
• Experience in Azure Development, worked on Azure storage, Azure SQL Database and Virtual machines.

TECH-SKILLS OVERVIEW:

Operating Systems: Windows Server 2008R2/2012/2016

Language: SQL/T-SQL, C/C#, PowerShell, HTML5/CSS, JavaScript, Python, DAX

Relational Database: Microsoft SQL Server 2012/2014/2016 , Oracle 12c

Development Tools: Microsoft Visual Studio 2012/2013/2015

SQL Server Tools: SQL Server Management Studio (SSMS), SSRS, SSIS, SSAS, Informatica Power BI, Tableau, HadoopGit

PROFESSIONAL EXPERIENCE;

Confidential, Houston, TX

MS SQL/SSIS/ETL Developer

Responsibilities:

• Building Complex queries, Stored Procedures, Functions and Data analysis.
• Building queries, functions, and stored procedures to generate data with significant translation required in some cases.
• Working with vendors and team members to troubleshoot data anomalies.
• Working with various sources of data coming to a centralized SQL Server data warehouse.
• Building complex SSIS packages in order to automatic the loading process.
• Creating SQL Server reports based on the requirement using SSRS.
• Modifying, debugging and tuning the existing old Stored Procedures to meet the new requirements.
• Design Tableau/Power BI data visualization utilizing cross tabs, maps, scatter plots, pies and bar charts.
• Developed SSRS reports. Optimized SQL queries for processing huge result sets by rewriting the queries, implementing table-valued functions or stored procedures.
• Designed and enhanced the SSIS ETL packages and processes, implemented data transformation rules and data validations into the enterprise data warehouses (EDW).
• Designed and implemented Modular and Reusable ETL processes and associated data structures for Data Staging, Change Data Capture (CDC), Data Balancing & Reconciliation, Exception Handling & Reject Recycling, Surrogate Key Generation & Assignment, Data Lineage Tracking, ETL Auditing, etc.

Confidential, Pasadena, CA

SQL/SSIS/ETL Developer/Production Support

Responsibilities:

• Provides and supports the implementation of business solutions (e.g. develops data models, data movement processes, report development, etc.)
• Develops and supports the multidimensional semantic layer, meta-data and BI query objects for end user consumption.
• Writes complex SQL, queries, stored procedures, and functions from our relational and dimensional databases and objects for end user consumption.
• Developed SSRS reports. Optimized SQL queries for processing huge result sets by rewriting the queries, implementing table-valued functions or stored procedures.
• Troubleshoots BI-related problems, fixes bugs and tunes for performance.
• Collaborate with analysts and department leaders to design, build and customize reports and reporting packages using SQL Server, SSIS, SSRS, Tableau.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files, Oracle etc. to SQL Server using SSIS various features such as multitasking, conditional split, union, union all, merge, lookup, fuzzy lookup, data conversion.
• Develop MS SQL Business Intelligence (BI) reports and applications and other reports and applications using T-SQL, C#, and other designated tools.
• Develop custom calculated measures using DAX in Power BI to satisfy business needs.
• Troubleshoot Tableau related issues and queries.
• Develop an application use C# for data analysis team in order to pull the specific data they need.

Confidential, Chicago, IL

SSIS/SSRS/ETL Developer

Responsibilities:

• Participated throughout the project life cycle, from requirements to production implementation, with emphasis on development, testing and implementation of data warehousing infrastructure, analytic reports and tools.
• Worked with the Information / Data Architect and Database Designer / Modeler to help implement the physical data model to support the mission critical OLTP and OLAP production databases.
• Performed business analysis as it relates to business intelligence, data warehousing, and operational reporting systems.
• Performed the statistical analysis of data in the warehouse; Reviewed the customer’s requirements and determine if the business processes for gathering, cleansing, and ensuring the quality of data were adequate. Analyzed the options for preparing a BI solution.
• Responsible for the creation of BI reports, dashboards and other forms of information designed to gain new insights, monitoring key organizational and operational measures, and providing visibility of performance throughout the organization and customers.
• Troubleshooted the technical issues and tune at all layers of the ETL platform including the database, the data source, SSIS package, and the presentation layer.
• Managed the existing third-party data exchange relationships and worked with vendors, partners, and clients to define, implement, document, and maintain data exchange files, file specifications, and supporting business processes.
• Responsible to write very complex database queries, designed various SQL objects and applied performance tuning to enhance the accuracy of the data. Responsible for designing reports using Reporting Services 2014.
• Used python to automatic unzip multiple files and move to specific location.
• Provided day to day support of data warehouse and troubleshooting of existing process and procedures.

Confidential, Charlotte, NC

MS SQL SSIS/ETL Developer

Responsibilities:

• Designed, created and regular tuned of physical database objects (tables, views, indexes) in MS SQL Server 2014 to support normalized and dimensional models.
• Configured SQL Server maintenance plans to automatically back up SQL Server Databases, optimize index and update statistics
• Worked as a primary T-SQL developer in creating complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Used SQL Server Profiler and Extended Events to trace long running queries for optimizing databases.
• Performed code reviews, analyzed execution plans, and re-factor inefficient code Follows data standards, resolved data issues, completed unit testing and completed system documentation for ETL processes.
• Implemented the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Collaborated with system teams and development teams for codes release including Microsoft SQL database changes and patches.
• Documented All Microsoft SQL Server databases structures and functionalities. Worked with Auditors and Provided Database related documents.
• Evaluating SQL Server 2014/2016’s in-memory database engine to achieve performance gain.
• Design Power BI data visualization utilizing cross tabs, maps, scatter plots, pies and bar charts.
• Designed ETL processes (Informatica), implemented data transformation rules and data validations into the enterprise data warehouses (EDW).