SUMMARY

• Over 6 Years of experience in BI solutions using T - SQL, SSRS, SSIS, SSAS and Programming using DDL, DML, DCL commands and stored procedures for various business applications.
• Interacted with technical team and Business users to perform analysis of business requirements and transformed them into technical requirements for ETL and Reporting needs.
• Has very strong background in a disciplined Software Development Life Cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Experience in Database Normalization, Designing, Creating Indexes, Developed Queries and T-SQL Scripts in MS SQL.
• Experience in developing data driven Web Applications using Visual Studio and C# programming language.
• Experience in building Data Integration, Workflow Solutions and Extract, Transform and Load (ETL)solutions for data warehousing using SQL Server Integration Service (SSIS).
• Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc.)
• Creating and Managing users, roles and assigning necessary permissions.
• Experience in Creating Tables, Views, Complex Stored Procedures to facilitate efficient data manipulation, data integrity and other T-SQL (DDL, DML) statements for various applications.
• Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Designed SSIS Packages to extract data from various heterogeneous data sources such as Access database, Excel spreadsheet and flat files into SQL Server for further Data Analysis and Reporting by using multiple transformations provided by SSIS.
• Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modelling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimension Tables using Analysis Services.
• Expertise in creating complex SSRS reports against OLTP, OLAP databases.
• Extensive experience in designing and developing rich user experience reports using Matrix, Tabular, Drill down/up, and Drill through features in using Business Intelligence Development Studio (BIDS).
• Having Knowledge in creating different kinds of reports using varies charts and Dashboards using POWER BI.
• Experience in different type of reports including Tabular forms, Matrix form, Conditional, Drill down, List items, Charts and Sub Reports.
• Experience in using Expressions to customize SSRS reports dynamically.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Experience in creating Packages, Jobs and Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server
• Hands on experience with performing various SSIS data transformation tasks like Lookup, Conditional Splits and Event Handlers, Error Handlers etc.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• End to end experience in designing and deploying data visualizations using Tableau.
• Worked on various types of charts and reports and developed dashboards using Tableau.
• Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectation.
• Responsible for Reviews and documentation for reporting the status to the project manager.
• Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

RDBMS: Microsoft SQL Server 2012/2008R2/2008/2005 and Oracle

Programming: T-SQL, PL/SQL, Dynamic SQL, MDX, C#, .Net and XML

Databases: MS SQL Server, MS Access, Oracle 11g,10g,9i, PostgreSQL

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS)

SQL: SQL Server Data Tools and Business Intelligence Studio.

Reporting Tools: SSRS, Power BI, Tableau, Excel.

Tools: SQL Server Management Studio, SQL Developer and TOAD.

Version Controls: Team Foundation Server (TFS), Visual Source Safe (VSS), Collabnet

Operating Systems: Windows 10, Windows 8.1, Windows 7, Windows 2000, Server 2003, Server 2008, Server 2012, Linux, Unix.

PROFESSIONAL EXPERIENCE

Confidential, Denver-Colorado

SQL MSBI DEVELOPER (SQL SERVER/SSIS/SSRS/POWER BI/TABLEAU)

Responsibilities:

• Interacted with technical team and Business users to perform analysis of business requirements and transformed them into technical requirements for ETL and Reporting needs.
• Created SSISPackages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server.
• Formulated and documented ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations and expressions.
• Created stored procedure and function to support efficient data storage and manipulation.
• Created package to validate, extract, transformation and load data to centralize SQL Server using OLEDB providers from existing diversified data source.
• Created packages in SSIS with error handling as well as created complexSSISpackages using various transformations and tasks like Sequence Containers, Script, For loop and For Each Loop Container, Execute-SQL, Execute Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge, Merge Join, Row Count, Sort, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.
• Building the SSIS packages to load the Data into Staging, ODS and dimensional model.
• Developed ETL process using SSIS to transfer data from heterogeneous data sources.
• Designed and developed SSIS packages using various control flow and data flow items to transform and load the data from various databases and into server integrations services (SSIS).
• Create package include a variety of transformation, Slowly Changing Dimension, Look up, Aggregate, Derived column, conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Configured package with checkpoints, package logging, error handling and event handling to redirect error rows and fix the error inSSIS.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Expert on creating multiple kind ofPower BIReports and Dashboards.
• Developed confidential proprietary analytical tools and reports with Microsoft Excel, and Power Pivot, andPowerPoint.
• CreatedPowermap and Tableau Map reporting (heat and Polygon report).
• Developed confidential proprietary analytical tools and reports with Microsoft Excel, andPower Pivot, andPower BIPoint.
• Created, Maintained & scheduled various reports inPower BI like Tabular Reports, Matrix Reports.
• Developed Lookup Transformation package for data matching, compare source and destination data based on id and get the new and updated records and then we use conditional split to select that new records before inserting into the database.
• Worked on managing ETL process by pulling large volume of data from OLTP to a staging Database Using SSIS for Data transformation.

Environment: Windows Server 2003/2008/2012 , MS SQL Server 2005/2008/2012 , Visual Studio 2008/2012, SSRS, SSIS, MS Office, SharePoint, Oracle, Tableau 9, Power BI.

Confidential

MSBI DEVELOPER (SQL SERVER/SSIS/SSRS/T-SQL/TABLEAU)

Responsibilities:

• Requirement gathering, creation of requirement specification documents for new SSRS reports.
• Involved in developing documentation to reflect current design of SSIS ETL processes. Worked closely with Business Users in identifying the gaps between existing code and the business requirements in the ETL projects.
• Developed various T-SQL scripts for transaction processing of Sales, Credit and Rebates.
• Created Dashboards, Reports, Datasets using Tableau.
• Designing and Development of Analysis Reports, Charts, Dashboards using Tableau.
• Interact with business users to refine the requirement and also explain end to end change.
• Gathered user requirements and converted them into Logical and Physical data models.
• Developing SSRS Reports and Deploying reports to other environments (UAT, PS and production).
• Generated various list Reports, Grouped Reports, Charts Reports, Drill-Down and Drill-Through Reports.
• Requirement Gathering, impact analysis, and design documentation creation for existing SSIS, SSAS cubes and SSRS reports.
• Expert on creating multiple kind of Tableau Reports and Dashboards.
• Designed and developed various SSIS packages for the weekly & monthly Loads.
• Developing and processing of SSAS cube.
• Written MDX Scripts in order to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Worked on enhancement related to developing new packages, reports and cubes and data fixes for the existing packages, cubes and reports.
• Perform unit-testing conduct UAT and bug resolution.
• Preparing test cases, execute test strategy and deployment activities.
• Defect fixing for the changes during UAT phase.
• Projecting the status of assigned items to Stakeholders.

Environment: MS SQL Server 2005/2008, SQL Server Reporting Services (SSRS 2012/2008/2008 R2), SQL Server analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), T-SQL, Tableau 8, MS Office, SharePoint, MS Excel Team Foundation Server (TFS).

Confidential

BI Analyst

Responsibilities:

• Develop business architecture using requirements such as scope, processes and requirements.
• Communicate client’s business requirements by developing easy to understand process and diagrams.
• Draft and maintain business requirements and specify technical and functional requirements.
• Provide input into developing and modifying systems to meet client needs and develop business specifications to support these modifications.
• Engage client to gather software requirements and ensure alignments with development teams.
• Evaluate risks related to requirements implementations, testing processes.
• Gathered user requirements and converted them into Logical and Physical data models.
• Facilitate monthly meetings with clients to document requirements and explore potential solutions.
• Good Hands on experience in various diagrams such as Use Case Diagrams, Sequence Diagrams and Data Flow Diagrams.

Environment: MS SQL Server 2005, SQL, C#.net, Visual Studio, ASP.net, SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), T-SQL, MS Excel, and Visual Source Safe, HP Quality Center.

Confidential

ASSOCIATE BI DEVELOPER

Responsibilities:

• Involved in analysis of specifications provided by clients along with team members and team lead.
• Developed new module as per the business requirements.
• Executed SQL commands, wrote SQL commands, Stored procedures for existing intranet applications.
• Writing client side programming using HTML, JavaScript.
• Involved in testing of the system.
• Reviewing the code and performing quality check.
• Created stored procedures for module integrity and application.
• Managed ongoing activities like importing and exporting, backup and recovery.
• Developed SQL Queries to check Data Quality.
• Design and develop new modules.
• Involved in System Integration testing and Unit testing. Developing the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Deploying scheduling and Monitoring SSIS packages.
• Daily, Weekly and Monthly production data processing, monitoring and trouble-shooting in an environment of mission critical operational systems.
• Debugging and Troubleshooting SSIS packages.
• Writing complicated T-SQL queries and performing performance tuning checks on the existing ones.
• Administered of all SQL Server database Objects, Logins, users and permissions in each registered server.

Environment: MS SQL Server 2005, SQL, PL/SQL, Oracle 9i, C#.net, Visual Studio, ASP.net, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), T-SQL, MS Excel,VB.net and Visual Source Safe.