SUMMARY

• 16 years of IT experience in development, testing, implementation, upgrade and support of commercial applications.
• Microsoft Certified Technology Solution specialist (MCTS). Around 14 years of experience in data warehousing and business intelligence projects as Technology Solution specialist using technologies like SQL Server, SSIS, SSRS, SSAS and Power BI
• Experience in Analysis, Design, Development, Testing and Maintenance, support of application systems of OLAP databases.
• Strong knowledge and Experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Complex Views, Dynamic SQL, Triggers and Cursors.
• Strong knowledge and ability to write stored procedures, using temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions.
• Extensive experience with data modeling techniques, logical and physical database design.
• Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas and FACT and Dimensions Tables using SQL Server Analysis Services (SSAS).
• Hands on experience in creating MDX queries to query Analysis services databases
• Expert in creating Excel Pivot Table Reports.
• Experience in writing complex SQL queries involving multiple tables, inner and outer joins, and stored procedures.
• Extensive experience with SQL Performance tuning and transactions analysis, thorough understanding of index and statistics
• Expertise in Power BI tools such as Power Pivot & Power View.
• Strong Analytical skill and Trouble shooting skills.
• Efficiently helped in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation.
• Used SQL Profiler to troubleshoot SQL Server/Hardware issues.
• Hands on experience with performing various data transformation tasks like Look - ups, Fuzzy Look-ups, Merge Joins, Conditional Splits and Event Handlers, Error Handlers etc in SQL Server Integration Services (SSIS).
• Experience in developing Dashboard, Ad-hoc and Parameterized Reports, drill down reports using SQL Server reporting Services (SSRS).
• Experience in gathering business requirements and translating them into technical specification and creating reports with respect to business requirement.
• Well versed in understanding and translating business requirement into technical specifications to ensure a successful Design, Development, & Implementation cycle. Involved in every stage of the software development, from planning, architecture, design, coding to unit-testing using SDLC, Agile Development and SCRUM methodologies
• Strong knowledge of data warehouse, data mart and dimensional modeling.

TECHNICAL SKILLS

Tools: SSIS, SSAS, SSRS, PPS, CodeFlow, TFS, Power Pivot, Power View

Languages: VB, HTML, Java Script, T-SQL, MDX, XML

Databases: SQL Server, Microsoft Azure

OLAP Tools: SSAS, Tabular Cube

Reporting Tool: SSRS, PowerPivot, PowerView, PowerBI

Operating Systems: DOS, Windows

PROFESSIONAL EXPERIENCE

Confidential, Hanover, MD

Senior Analyst - IT

Responsibilities:

• Transition the solution into a fully Interactive Reporting system.
• Provide interactive dashboard reports to the users.
• Remove technical dependency on business users
• Better integration with IT global systems with recognition that the solution has to support imperfect data inputs.
• Reduce the business’ IT related activities (development, maintenance and support, back-up activities)

Technology: SQL Server, SSIS, SSRS, Microsoft Azure and Power BI

Senior Analyst - IT

Confidential

Responsibilities:

• Involved in gathering Business Requirements.
• Advanced extensible reporting skills using Microsoft Power BI .
• Designed and created Report templates, bar graphs and pie charts based on the station utilization data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports, Power Pivot.
• Created Dashboards and Score Cards.
• Actively involved in gathering, understanding and validating the project specifications.
• Involved in creating and designing SQL Server Datawarehouse and Creating Tables, Views, Store Procedures, functions etc.
• Designed and Created Multiple Reports using SSRS tool. Involved Tabular, Matrix, Drill-through and Drill down reports.
• Developed complex SQL queries using various Joins, Views, Functions and Triggers.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring complex business logics and detail-level data analysis.
• Used various features such as Slowly Changing Dimension, Checkpoints, Import Column, Export Column and Data Conversion Transformations.
• Involved in development, enhancement, testing and performance tuning of the application
• Designed and Developed Complex Vendor Drive Analytical engine and Reports
• Designed and Developed Datamart Planning Engine and Reports.

Confidential, Hanover, MD

Technical Architect

Responsibilities:

• Involved in gathering Business Requirements.
• Actively involved in gathering, understanding and validating the project specifications.
• Involved in creating and designing SQL Server Datawarehouse and Creating Tables, Views, Store Procedures, functions etc.
• Designed and developed SSIS Packages to extract data from Source server and flat files into SQL server 2008 R2 Datawarehouse. ETL is created using various control flow items Sequence Container, for each loop, execute SQL etc. and data Flow transformations, conditional split, derived column, lookup, sort, Data conversion etc.
• Designed and Created Multiple Reports using SSRS tool. Involved Tabular, Matrix, Drill-through and Drill down reports.
• Developed complex SQL queries using various Joins, Views, Functions and Triggers.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring complex business logics and detail-level data analysis.

Confidential

Technology Lead

Responsibilities:

• Involved in gathering business rules and business requirements to validate data
• Create reports using Microsoft Reporting Services (SSRS), Excel and Power BI
• Created Excel Pivot table reports and implemented conditional formatting
• Created leadership dashboards for Top level managers
• Generated SQL scripts to create or drop database objects including tables, indexes, Stored Procedures, Views and Triggers.
• Created SSIS Packages to Extract, Transform and Load data from different sources.
• Created joins and sub-queries for complex queries involving multiple tables
• Helped Operations team at the time of deployment.
• Used Team Foundation Server (TFS) for central repository as a versioning control
• Design Dimension modeling and create Cubes.
• MDX queries to query Analysis services databases
• Developed Tabular Cubes
• Wrote VBA and Macro in excel reports to refresh reports

Confidential, Bellevue, WA

Technology Lead

Responsibilities:

• Conduct Requirements gathering and analysis meetings with stakeholders
• Design and development of modules.
• Created Test cases and test automations.
• Created Views to reduce database complexities for the end users
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008R2
• Developed SSIS Packages using Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS)
• Generated Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS
• Developed new tables, stored procedures, functions, views, triggers, data models and SSIS packages for the new database