SUMMARY

• Highly motivated Business Intelligence Professional with 7+ Years of experience in Business Intelligence and Data Warehouse Solutions.
• Thorough understanding of BI applications such as SSMS, SSIS, SSRS, SSAS in Development, Test and Production Environments, visualization tools such as Power BI and Tableau.
• A wide experience working in different industry domains such as healthcare, service, insurance and finance.
• Excellent in High Level Design of ETL Packages and SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV and flat files, MS Access, SAS, Oracle, DB2, Salesforce, CRM) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Derived Column, Merge, Merge Join and Union all.
• SQL/ETL Developer having 7 years of IT experience in Requirement Gathering, Analysis, Design, Development and Implementation of Enterprise solutions.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2016/ 2014/2012/2008 R2/2008.
• Data Modeler with strong Conceptual, Logical and Physical Data Modeling skills, has experience with JAD sessions for requirements gathering, creating data mapping documents and queries
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Experience in report development using SSRS and creating various types of reports like Dashboard, Drill Down/Through, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Experience in SQL server MDS 2012 features including hierarchies, granular security, transactions, data versioning, and business rules.
• Experience in working with Web services to handle SQL connections.
• Strong skills on deploying and operating large scale cloud infrastructure and application services in AWS, Azure, SAP, Oracle Cloud, Google Cloud, IBM Software and other Cloud providers
• Strong knowledge with Host Scripting to automate routine tasks.
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T - SQL.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Experience in Performance Tuning and Query Optimization.
• Well versed in Performance Point Server 2007. Designed Dashboards, Scorecards and reports using multiple KPI's, OLAP charts and SSRS Reports with PPS.
• Experience in maintenance and administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Generated Data to support SAP Business Objects Interface for Users to access data from Data Warehouse.
• Expert in creating Parameterized Reports.
• Hands on experience in creating Star Schemas and Snow Flake Schemas.
• Excellent analytical, communication and interpersonal skills and proficient in writing and presenting complex technical concepts, comfortable working independently and with different size of teams.
• Proficient in Software Development Life Cycle (SDLC) process, which includes RUP, Agile and Waterfall methodologies.
• Involved in designing and populating data in data warehouse and Cubes (OLAP) using SSAS and SSIS.
• Migrated on-premise SQL Server schemas to the cloud on Azure SQL Server DB and Azure VM, and developed and maintained databases across both on-premise and cloud deployments.

TECHNICAL SKILLS

OS: Windows XP/7/10, Windows Server 2016/12/08, UNIX/LINUX

Databases: SQL Server 2016/14/12/08 R2, Oracle 11g/8.0i, MS Access 2000/8.0, Teradata 14.0, DB2

Languages: T-SQL, PL/SQL, MDX, DAX, C#, VB.NET, XML, MYSQL, HTML, ASP.NET, .NET Frame Work, C#, C, C++, JavaScript

Web Tools: C#.Net, ASP.Net, VB.Net, Visual Studio.Net, XHTML1.0, JavaScript, VB Script

ETL & Reporting: SSDT 2016/14/12, BIDS 2008R2/08, SQL Server Integration Services (SSIS 2016/ 2014/2012/2008 R2), SQL Server Reporting Services (SSRS 2016/2 R2), PowerBI, SQL Server Analysis Services (SSAS)

Others: MS Office, Crystal Reports XI, Visio, Service Oriented Architecture (SOA), SQL Server Notification Services, Visual web developer, MS FrontPage, Windows Scripting Host, Erwin Data Modeler, MS Visual, SAS/Access, Crystal Reports SAP Business Objects, DataStage, Informatica, Hadoop, Micro Strategy, ER-Studio, Confidential TFS, Confidential GIT, MS VSS, Synergy, HP Quality Center & Jira

PROFESSIONAL EXPERIENCE

Confidential, Allen TX

Senior SQL BI (SSIS, SSRS, SSAS, Power BI) developer

Responsibilities:

• publishingPowerBIreports on dashboards inPowerBIserver.
• Developed analytics solutions by defining and translating business requirements into dashboard & reporting solutions and implementing them within MicrosoftPowerBIDesktop and visualizations deal with the backend data retrieval team, data mart team to guide the proper structuring of data forPowerBIreporting.
• Created XMLPackage Configurations,Error Handling usingEvent Handlersfor On Error, On Warning, On-Task Failed event types.
• Extended SSIS Capabilities by Creating Custom SSIS Components for SharePoint.
• Performed SSIS Development and support, developed ETL solutions for integrating data from multiple sources like Flat Files (delimited, fixed width), Excel, SQL Server, Raw File, and DB2 into the central OLTP database.
• Configured SSIS packages with XML configuration file, Environment variable, Registry entry, Parent package variable and SQL Server table.
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in thePowerBI. accurate Data Models; adding the calculated DAX measures on top of the datasets wherever required.
• Responsible to managedatacoming from different sources.
• Added required measures, calculated columns, keeping unnecessary columns hidden from reporting view inPowerBIapplication.
• Load and transform large sets of structured, semi structured and unstructureddata.
• Created and maintained tables, stored procedures, indexes, database check constraints, and business rules using SQL.
• Assisted in implementingAzureDataFactory v2 for a major financial institution by ingesting their risks and controldataintoAzuredatalake store.
• HandlingAzureStorage like Blob Storage and File Storage
• Developed U-SQL Scripts for schematizing the data inAzureData Lake Analytics
• Ability to create scripts usingAzurePowerShell during for automation and build process.
• Participated in design discussions with Database architects and Application architects.
• Developed SSIS packages to extract, transform and load data from Oracle and SQL Server databases into Data Warehouse.
• Deployed SSIS packages into various Environments (Dev, UAT and Prod) using Deployment Utility.
• Coordinated with Users in different testing phases.
• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.
• Strong Applications Development experience with back-end databases such as SQL Server, Oracle and MS Access using ADO/ADO.NET, OLEDB and SQL client.

Confidential, San Francisco CA

Sr. SQL BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Gathering, analyzing and documenting the business requirements and business rules by directly working with end users/clients.
• Created and maintained documents like Documentation Roadmap, DATA Models, ETL Execution Plan, Configuration Management Procedures, and Project Plan.
• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in scheduling and deploying SSIS Packages.
• Published SSRS reports in Report Manager, SharePoint web pages and in custom made ASP.NET web applications.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL codes and SQL joins for SSIS packages and SSRS reports.
• Extract, Transform and Load data from databases of systems like CRM, ERP and SharePoint
• Design, maintain and deliver SSRS reports sourcing from central database.
• Developed C#/VB console and web applications to manipulate databases and perform calculations
• Created Application Tracking Systems, Surveys and Manual Data Entry Web Apps using ASP.NET Framework.
• Implemented various tasks and transformations for data cleansing and performance tuning of SSIS packages.
• Extracted and Loaded SharePoint Lists and Surveys Data into SQL Server Database with SSIS
• Collaborated on multiple projects using GITHUB.
• Provided standard and ad-hoc reports on a regular basis and on demand.
• Worked extensively on system analysis, design, development, testing and implementation of projects.
• Developed and Maintained Crystal Reports.
• Pulled data into MS SQL Server Database from different DBMS databases like Oracle and Teradata with ETL packages.
• Created SSRS and PowerBI reports sourcing from SSAS’s Multidimensional OLAP and Tabular model cubes with MDX and DAX.
• Created and scheduled Various SQL Jobs, using SQL Server Agent to perform various Administrative tasks.

Confidential, Purchase/NY

Responsibilities:

• Created Complex ETL Packages using SSIS for extracting, cleaning, transforming and loading data from staging tables to partitioned tables with incremental load.
• Developed, deployed, and monitored SSIS Packages.
• Implemented data validation by using T-SQL queries to confirm that SSRS reports data results that are being returned are correct.
• Making changes to existing ETLs and building some new ETL processes.
• Data Automation Using SSIS to automate data processes for input of information.
• Worked and communicate closely with project team members to achieve project goals.
• Created packages using the various control flow tasks such as Data Flow Task, Execute SQL Task, Execute Package Task, and File System Task.
• Administered SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer.
• Created number of standard reports and complex reports to analyze data using Slice & Dice, Drill Down and Drill Through approaches using SSRS.
• Created Indexes for faster data retrieval from the database.
• Designed the Data warehouse and done the mappings from Source to the Target tables.
• Identified the dimension, fact tables and designed the Data-Mart using Star schema.
• Wrote Stored Procedures and Functions for better performance and flexibility.
• Formatted/Generated Data to support SAP Business Objects Interface for Users to access data from Data Warehouse.
• Good hands on experience with C#.NET and VB.NET for downloading files from a remote server.
• Strong skills in transformation data from DB2 to SQL Server
• Created and Designed Data Source and Data Source Views and configured OLAP Cubes (Star and Snow Flake Schema) using SSAS.
• Involved in Dimensional Data Modeling and Cube Partitioning in SSAS and enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions using SSAS.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Developed Multidimensional Objects (Cubes, Dimensions), designed Dimensional Modeling and created Hierarchies using SQL Server Analysis Services (SSAS).
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Defined appropriate measure groups and KPIs and deployed cubes.
• Created Parameterized, Cross-Tab, Drill Down and Summary reports by Using SSRS and created report snapshots to improve the performance of SSRS.

Confidential, Chicago, IL

SQL BI SSIS, SSRS/PowerBI Developer, Conversion-Data Analyst

Responsibilities:

• Involved in writing heavyT-SQL stored procedures, complex joins, new T-SQLfeatures like Merge, Except commands
• Dealing with automatingSSIS Packages usingSQL Server AgentJobs, Windows Scheduler, and third-party tools.
• Worked with re-directing outputs into different formats including XML Files and various other data sources.
• Improved data standards, data exchange, XML data standard or data sharing model.
• Developed SSIS packages usingLookup Transformations, Merge Joins, Fuzzy Lookups, and Derived Columnswith Multiple Data Flow tasks.
• Involved in several transformations in Data Flow including Derived-Column, Script, Slowly Changing Dimension, Lookup, Data Conversion, Conditional-Split and many more.
• Worked on XML Web Services Control Flow task to read from XML Source.
• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Developed ETL solutions for integrating data from multiple sources like Flat Files (delimited, fixed width), Excel, SQL Server, Raw File and DB2 into the data warehouse.
• Interpreted data, analyzed results using statistical techniques and provided ongoing SSRS and PowerBI reports.
• Created, maintained and updated ETL packages loading from/to both OLTP and OLAP database tables.
• Developed and implemented data collection systems and other strategies which optimize statistical efficiency and data quality.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Identify, analyze, and interpret trends or patterns in complex data sets.
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
• Acquire data from primary or secondary data sources and maintain databases/data systems
• Filter and “clean” data, and review computer reports, printouts, and performance indicators to locate and correct code problems.
• Converted old ETL packages to the new version (did optimization by applying more stored procedures instead of using control flow tasks).
• Work closely with management to prioritize business and information needs.

Confidential, Pearland, TX

SQL/SSIS Developer, Data Modeler

Responsibilities:

• As a key member of BI team, accomplished successful outcomes by working with SSIS, SSAS and SSRS.
• Supported the Project Manager in leading multi-functional project teams in implementing data conversion strategies and communicating essential information to team members.
• Trained/guided new or junior developers in certain development areas helped them to understand better the project process.
• Participated in formal and informal training programs to improve technical skills and knowledge of all programmers (e.g. lunch and learns, articles, white papers).
• Solved many critical/challenge issues raised by the team about ETLs.
• Created the optimal logics to load the data that business rules were based on flat file names or ragged hierarchy.
• Wrote C# hard codes in script task for ETLs, updated/maintained the ETL packages with high performance.
• Created Incremental Load ETL packages using For Each Loops, Sequence Containers, Script Tasks, Conditional Split, Data Conversation, Derived Column, Lookup, Merge/Merge Join, Union all, etc. on BIDS 2008R2/2012.
• Participated in software quality assurance activities, including code reviews and unit system, integration, regression and performance testing.
• Understood and completed necessary documentation for the application/infrastructure change control process.
• Worked closely with business people and analyst team to deeply understand/analyze the requirements of business need and achieved the successful results.
• Developed ETL solutions for integrating data from multiple sources like Flat Files (delimited, fixed width), Excel, SQL Server, Raw File, DB2, Oracle, and SAP into the data warehouse.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Developed complex T-SQL Stored Procedures, UDFs, CTEs, Indexed Views, and Staging Tables to process the data and populate them into the appropriate destination tables.
• Built efficient SSIS packages for processing Fact and Dimension tables with complex transforms and type 1/ type 2 changes.
• Administered the maintenance and movement of 835 files through clearinghouse and direct connection.
• Worked with EDP Power Reader to manage 835 files and involved in EDI Medical Claims Analysis, Design, Implementation and Documentation.
• Converted old ETL packages to the new version (did optimization by applying more stored procedures instead of using control flow tasks).
• Worked with the team/architect to create logical/physical modeling and created Cubes (fact, dimensions and calculations)
• Worked on various DAX expressions in Power Pivot based on the business requirement.
• Worked and updated to improve complex issues like Error Handling in SSIS for handling Delta load changes.
• Performed debugging, data analysis, and system analysis as required.
• Hands on Creating Parameterized reports, Cross-Tab reports, Drill down reports, Dashboard and Summary reports by using SSRS.
• Designed high level ETL architecture for overall data transfer from the OLTP to Data warehouse with SSIS and prepared ETL mapping processes.
• Created local variables and global variables package configurations and error handling.