SUMMARY

• Having 5+ years of experience in Business Intelligence & Data Warehousing.
• Analysis, Design, Development and Implementation of operational database systems (OLTP) and data warehouse systems (OLAP) using MSBI such as SQL Server Integration Services(SSIS), SQL Server Analysis Services(SSAS) and SQL Server Reporting Services(SSRS).
• Worked on different projects with best industry standard experience implementation (SDLC), troubleshooting, presentation abilities and issue resolution capabilities.
• SSRSreports and SSAS modelsarepresentedto Decision Support Systems (DSS)for top management.
• Quick understanding of business anddomainwithsourceand target systems.
• Expertise in understanding Fact Tables, Dimension Tables and Summary Tables.
• Expertise knowledge and experience in deploying SSIS packages, SSRS reports and SSAS Cubes to DEV, TEST and PROD Server.
• Worked on performance improvement, ETL migration, Environment setup and admin activities.
• Experienced in enhancing data warehouse with extensive knowledge of Datamapping,Data Modeling, Snowflake, Star Schemas,ETL jobs and OLAP operations.
• Created interactive dashboards in Power BI reports that were presented to Business users, Program managers and End users.
• Expertise in What - If Analysis using Excel, Power Pivot Reports and Drill Through Dashboards using Warehouses and OLTP Connections
• Experience in writing expressions in SSRS and Expert in fine tuning the reports.
• Created many Drill through and Drill Down reports using SSRS and Power BI.
• DAX querylanguage used in Power BI, Tabular Model of SSAS and MDX query language used in multidimensional model of SSAS.
• Master in performing administrative tasks: database files management,backup/restore, data integration and synchronization.
• Experience in creating Jobs, Alerts, SQL Mail Agent and scheduled DTS/SSIS Packages.
• Experience in SQL tuning using Hints, Materialized Views.
• Expertise in Functional testing, Manual Testing and Automated Testing, Regression testing, User Acceptance testing (UAT), System testing and Integration testing.
• Experience in Agile and waterfall models to deliver the projects and used JIRA tool for Sprint planning and tracking the project status.
• Excellent communication, interpersonal skills, self-starter, enthusiastic, eager to meet challenges and quickly assimilate latest technologies concepts and ideas.

TECHNICAL SKILLS

Database Tools: MSBIData Tools 2005/2008/ 2012 (SSIS, SSRS, SSAS), Power BI, Power Excel, Power Pivot, Data Transformation Services (DTS)- Import/ Export Data, Bulk Copy Program (BCP)

Databases: MS SQL Server 2014/2012/2008/2005/2000 , Oracle 8i/9i/10g/11g,MS Access, DB2 and Teradata

Language: SQL, T-SQL, PL/SQL, VB.NET,Java Script, HTML, Script and Query Languages for Cubes (DMX, DAX)

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams.

Tools: and Utilities: Toad, ALM,Jenkins, Autosys,JIRA, Git and TFS

Operating System: Windows server 2008/2008 R2,2012,2014 Windows 7,8,10/XP and UNIX

PROFESSIONAL EXPERIENCE

Confidential, NJ

SQLBI/PowerBIDeveloper

Responsibilities:

• Error Handling and Logging done to control and prevent data leakage.
• Responsible for Deploying the SSISpackages.
• Auto scheduled the package through Jobs in SQL Server Agent.
• Experience in optimizing Microsoft Power BI dashboards with a focus on usability, performance, flexibility, testability and standardization.
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
• Created reports in PowerBI preview portal utilizing the SSAS tabular via Analysis connector.
• Report refresh and publish are auto scheduled in Power BI report serverondaily, weekly andmonthlybasis.
• Used the Bulk Copy Program(BCP) to load the large volumes of data from files into tables.
• Mail Task used to send mails to client and admins about the scheduled package auto run status.
• Worked with business analysts for requirement gathering, business analysis and translated the business requirements into technical specifications to build the Enterprise data warehouse.
• Created various database objects as for business logic demands like Stored Procedures, Tables, Views, Indexes etc. based on user requirements.
• Created SSIS packages to extract, transform and load data into data warehouse.
• Created transformations to manipulate data using Lookup, Derived Columns, Conditional Split, Term extraction, Aggregate, SCD, Script component, Pivot, Unpivot, Merge etc.
• Used many Tasks like Execute SQL Task, Data Flow Task, Execute Package Task and Script Task etc.
• Create Generic Reports and Dash boards in Power BI.
• The reports are generated on various Business Needs, Categories and demographics using SQL Server Reporting services (SSRS).
• Created Table, Matrix, Tablix, Chart, Drilldown reports, Parameterized and Cascaded reports according to business requirement.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Utilizing the Azure platform for various cloud computing functions such as provisioning virtual machines and data management.
• Created ETL metadata reports.
• Extensively worked on Data Cleansing, Data Analysis and Monitoring Using Data Quality Services.
• Designed complex reports like dynamically driven parameterized reports, reports with sub reports, drill through reports using SQL Server reporting services.
• Reports distributed based on defined roles like top executives, Business analysts and customer representatives.
• Used Erwin for data modeling and Dimensional Data Modeling.

Environment: MS SQL Server 2008/2012, MS Business Intelligence (MSBI),MSExcel, Oracle, JIRA,, Power BI, Git, and SQL Server Toad.

Confidential, Raleigh NC

MSBI Developer

Responsibilities:

• Importing data to PowerBI from various sources.
• Creating source and target table definitions using SSIS. Source data was extracted from Flat files, SQL Server, Oracle and DB2 Databases.
• Responsible for cleansing up database for maintenance of the database.
• VB.Net and other .NET languages C# used in Script task to control the flow of SSIS packages.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Experience in developing scripts in SSIS to synchronize stored procedures, email output and log messages.
• Extensively worked on production support that includes Deployment of SSIS Packages into Development, Unit Testing, Production Servers, Creating, Scheduling and Managing the SQL Jobs.
• Involved in Software Development Life Cycle (SDLC) including analysis, design, development and testing of the project.
• Installed and administered Microsoft SQL Server, SQL Server Integration Services, SQL Server Reporting Services.
• Designed and develop Dashboards and Reports using Power BI and SSRS.
• Solid knowledge of Data Warehousing, strategies for ETL, identifying Metrics, Dimensions, Hierarchies and design dimensional schemas (Star, Snowflake).
• Involved in managing slowly changing dimensions (SCD), De-Normalization, Cleansing, Conversion and Aggregation.
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Power BI.
• Involved in the data analysis for source and target systems and good understanding ofData Warehousing concepts, staging tables, Dimensions, Facts and Star Schema, Snowflake Schema.
• Implemented Performance Tuning at various levelsandcreated indexes (cluster and non-cluster index).
• Designed, Developed, Tested, Published and maintained Power BI Functional reports, Dashboards.
• Participated in design of Staging Databases and Data Warehouse/Data marts using Star Schema/Snowflakes schema in data modeling.
• Experienced working in the Agile methodology.

Environment: SQL Server, MS Business Intelligence (SSIS, SSRS), Oracle, DB2, T-SQL, PL/SQL, Toad, Unix, Autosys,PowerBI,Hive,Hadoop,Confluence, Git,Sqoop and HDFS

Confidential - NJ

MSBI Developer

Responsibilities:

• Performed daily tasks including backup and restore from disaster recovery by using SQL Server 2008/2012 tools like SSMS, SQL ServerProfiler.
• Experience in UNIX shell programming.
• Migrated existing DTS packages to SSIS.
• Experience in Designing, building the Dimensions, Cubes on star and snowflake schema using SQL Server Analysis Services (SSAS) for business analysis.
• Troubleshoot BI tool problems and provide technical support as needed. Perform other tasks as assigned.
• Developed Custom Sales, Inventory and financial reports for seasonal, quarterly, monthly and weekly using SSRS.
• Responsible for migration code between various environment and production release at the end of each Sprint.
• Developed slowly changed dimensions (SCD) Type 2 for loading data into Dimensions and Facts.
• Implementing and maintaining database security (Create and maintain users and roles and Login access, assign privileges) to each schema level permission.
• Worked with business users/Analytics team, data architects to identify the business requirements and developed designed document for ETL flow, analysis of database architecture, created various complex Packages using SSIS.
• Designed and Created database objects based on business requirements.
• Improved the performance of queries by introducing clustered and non-clustered indexes on tables in the database.
• Involved in various knowledge transfers from dependent teams understand the business activities and application programs and document the understandings for internal team referencing.
• Involved, Conducted and participated in process improvement discussions and recommending possible outcomes and focused on production application stability and enhancements.
• Created very complex SSIS Packages with considering all the best practice like errorhandling, logging, configurations, deployments and maintenance.
• Configuration and Deployment of the Reports (RDL, RDS) which were created inSSRS.
• Initiate the data modeling sessions, to design and build/append appropriate data mart models to support the reporting needs of applications.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.
• Created the various kinds of reports using SSRS i.e. Cached reports, Ad hoc reports, Clickthrough reports, Drilldown reports, Drill through reports.
• Migrated existing Crystal reports to SSRS reports.
• Developed Audit Strategy to validate the data between Source and Target System.
• Stored Procedures created in T-SQL for reports and ETL process.
• Developing the unit test case document and performed various kinds of testing like unit testing, regression testing and system test in Dev, QA environments before deployment.
• Code history maintained in Team Foundation Server (TFS).

Environment: MSBI (SSIS/SSRS/SSAS), SQL Server, Oracle, Teradata,Unix, JIRA and TFS.

Confidential

SQL Server Developer

Responsibilities:

• Experience in designing, developing, and implementing entry level workflow solutions with heterogeneous sources and multiple operating system environments.
• Extensively used various SSIS Objects such as Dataflow and Control Flow Elements, Connection Managers(Connections), Event Handlers and Progress Tab etc.
• Validated and modified data using SSIS with different Data Flow Transformations like Send Email Task, File System Task, Conditional Split, Lookup, Merge Join, Aggregate, Multi-Cast, Derived Column and Data Conversion etc.
• Responsible to meet with business stakeholders and other technical team members to Gather and analyze application requirements.
• Performed source/target analysis of data structures & content.
• Developed the SQL programs and Involved in optimize stored procedures and queries for faster retrieval and Server efficiency SSIS.
• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Worked with team members to tune the SQL queries. Created necessary Index/Partition on huge fact tables for getting a better performance in ETL.
• Implemented Logic with Database lookup table to maintain Parent- Child relationship and maintain hierarchy.
• Created reports in SSRS using different types of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Converted crystal reports to SQL Server reports using Reporting Services.
• Used ETL to implement the Slowly Changing Transformation to maintain Historical Data in Data Warehouse.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Used data compression techniques for Back Up.
• Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS from Heterogeneous databases such as Oracle, DB2and MS Access and designed data conversions from wide variety of source systems.
• Providing Production support to operational team for daily/weekly/Monthly job failure in Production environments.
• Created deployment documentation with the help of other users and operational team to deploy the new release in Production environment.
• Actively participated in the daily standup, planning, Review meetings.

Environment: MS SQL Server, MS Business Intelligence(SSIS, SSAS, SSRS),Oracle, DB2, T-SQLandTFS.