SUMMARY

• 6+ years of experience as a Business Intelligence /Analyst architecting, developing, deploying, and managing global enterprise business intelligence solutions in various industries.
• Experience working in all phases of Software Development Life Cycle (SDLC) using methodologies like Waterfall and Agile.
• Experience wif T - SQL, Integration Services (SSIS), Reporting Services (SSRS) and working noledge of Analysis Services (SSAS), Power BI.
• Proficiency in creating different types of Reports such as Table, Matrix, Drill-down, Drill-through, Summary, Parameterized, Sub reports and formatting them using SSRS.
• Expertise in building, sizing, Performance tuning, clustering, complex security structure of Business Objects and Tableau
• Good noledge of processes for creating and managing data warehouse, SQL code, report specifications, reports, and report sites.
• Experience in tuning Informatics Mappings, Sessions and SQL queries for better performance
• Good in Create complex queries, views and stored procedures for reporting and analysis.
• Understands and manages user data access security at various levels for Business Intelligence applications.
• Improved business processes by developing Purchase Order Change Requests forms and Blocked Invoice Tracker on SharePoint for the benefit of offshore team’s transactional activities.
• Efficient noledge in migrating universes, migrating reports (Crystal Report, SAP BO) to newer versions and documenting the process during the project life cycle.
• Good experience in Logical and Physical Data Modeling using Erwin and Visio, practical hands on experience in designing and developing ETL processes, star schemas and transformations.
• Experience in Installation and Configuration, creation of repositories and security domain wif user groups and security implementation
• Develop Reportsfocusing on website/email tracking, database queries and accounting.
• Good Knowledge in Enhancing and Deploying the SSIS Packages from Development Server to Production Server.
• Experience in writing Complex queries, stored procedures, functions, cursors, and packages using PL/SQL Programming. Design, development, and coding wif ORACLE, DB2, SQL Server Involved in migration of Business Objects.
• Good Interpersonal Skills, team-working attitude, takes initiatives and very proactive in solving problems and providing best solutions.

TECHNICAL SKILLS

Methodology: SDLC, Agile, Waterfall

Languages: SQL, PL/SQL,T-SQL

ETL Tools: SSIS

Data Modeling: Erwin, MS Visio

BI Tools: Business Objects, SAP BO

Database: Oracle, SQL Server, DB2

Other tools: Tableau, SSRS, SSAS, Crystal Reports, Power BI, SharePoint, MS-Office

Operating Systems: Windows, Linux

PROFESSIONAL EXPERIENCE

Confidential, MD

BI Developer

Roles & Responsibilities:

• Worked in Agile environment, wif an ability to accommodate and test the newly proposed changes at any point of time during the release.
• CreatedSSISpackages to extract Exchange Position Limits data from flat files, excel files, reformat the data and insert into database tables.
• Independently developed many SQL procedures, analyzed data in Master Well database usingadvance SQL group functions, sub-queries.
• Createddatabase,tableswifconstraints,indexes, developed manyT-SQL procedures, analyzed data using advanceSQL group functions, sub-queries.
• Created the data model for both the data warehouse and the data mart using Erwin as a modeling tool.
• Track and maintain Stakeholder requested enhancements and changes usingSharePoint.
• Closely worked wif Tableau support on product issues reported by various business users and tableau server or desktop.
• Based on the mapping document, wif the use of MS Visio have created Dimension and facts for the dimensional modeling in data modeling.
• Published and scheduled Business Objects Reports to users using broadcast agent to run the reports automatically.
• Design and implement data in various layers including physical, business and presentation.
• WrittenPL/SQLprograms onOracle, MS SQL Server Database and performedperformance tuning.
• Developed various types of Charts and Graphs like Bar Chart (Side by Side, Stacked), Line Graphs, Pie Charts etc. by using Chart expert of Crystal Reports and Web intelligence.
• Designed and developed executive dashboards and management reporting to support decision-making.

Confidential

MS SQL Server/BI Developer

Responsibilities:

• Developed business process models in Waterfall to document existing and future business processes.
• Worked as a database developer on databases like MS SQL Server using T-SQL, stored procedures, and views to get data from Data warehouse.
• Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel, Text file, XML file to different data Marts.
• Performed Incremental load wif several Dataflow tasks and Control Flow Tasks using SSIS.
• Configured Connection Manager Files and CMD files for SSIS packages to dynamically execute on QA Server and Production server.
• Made Master Child package using variables and Execute package task in SSIS, and transformations that SSIS provides.
• Deployed, Tested and Scheduled SSIS packages.
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly, and quarterly Reports including current status.
• Leading and mentor the efforts of data quality completeness initiative for SSIS based ETL architecture.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Developed incremental loading using MERGE statement in SQL and used slowly changing dimension (SCD).
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Used Execution Plane and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Responsible for performance tuning, optimizing the queries, removing redundant and inconsistent data, joins from the database tables and normalizing them.