SUMMARY

• Having 7 years of experience in the Analysis, Design, Development, Implementing Client/server application using Microsoft SQL Server and Business Intelligence Suite.
• Experience in writing SQL, T - SQL queries, creating clustered and non-clustered Index.
• Experience in Microsoft stack of BIsolutions - SSAS, SSRS, SSIS withSQL Server
• Experience in creating different types of Reports such as Cross-Tab, Drill-down, Summary, Parameterized, Sub reports and formatting them using SSRS.
• Experience in Extracting, Transforming and Loading (ETL) data from various sources to several destinations using SSIS.
• Experience in Extracting, Transformation and Loading (ETL) data using various tools including Bulk insert, Import/Export data and SQL server Integration Services.
• Experience in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources like SQL Server Native Client, Excel, Flat file using SSIS and DTS utility to SQL server.
• Experience in Enhancing and Deploying the SSIS Packages from Development Server to Production Server using Execute Package Utility.
• Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join, Sort, Data conversion, Pivot and un-pivot and Derived Column for cleaning bad data, validating the data.
• Experience in configuring SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors.
• Knowledge in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS)
• Experienced in database server performance tuning and optimization of Complex SQL queries.
• Experience in creating Packages, scheduling Jobs and sending Alerts using SQL Mail.
• Experience in Software Development Life Cycle (SDLC) specifically waterfall and Agile methodology.
• Expertise in designing Database Models using MSVisio.
• Experience in Building Reports/charts using Excel Power Pivot, Power View, Power Query, Power Maptools.
• Experience in Power BI, worked on PowerBI Desktop tools to build and customize, visualization on new or existing reports.
• Experience in creating power pivot data models and integrate them with SharePoint and schedule them to refresh.
• Knowledge on Tableau tools include Tableau Desktop versions 9.0.2/9.0.3 , Tableau Reader, Tableau Public and Tableau Server.
• Knowledge in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Ability and willingness to learn new technology and deliver results in a timely manner.
• A well-organized, goal-oriented, highly motivated effective team member.

TECHNICAL SKILLS

Programming Languages: SQL, T-SQL, HTML, Java Script and PHP.

Database: SQL Server 2005/2008/2012 (SSMS), Oracle, DB2

ETL Tools: SQL Server Integration Services (SSIS)

Reporting Tools: SSRS, SSAS, Cognos BI, Power BI and Tableau

MS Office: Excel

Others: Agile/Scrum Methodology

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

MSBI Developer

Responsibilities:

• Gathered requirements from IT top level management.
• Contacted Network engineers to learn about Solar Winds database.
• Created Target Databases, Tables, Cluster/Non-Cluster Index.
• Efficient use of Joins and sub-queries in queries that involve data from multiple tables.
• Validated data by writing SQL queries in source and target database.
• Developed SSIS package to pull required data from source and mapped them to target database.
• Created packages using different transformations like sort, derived column, union all and aggregate.
• Used different types of tasks like execute Sql flow task, data flow task, send mail task to extract and load data to target databases.
• Used sequence container to execute data flow tasks in parallel.
• Configured SQL Mail agent for sending automated alerts/email.
• Deployed SSIS package to SQL Server and scheduled it to run daily using SQL Server Agent.
• Generated custom and parameterized reports using SSRS.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs
• Created subscriptions to provide a daily basis reports. Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Build network related dashboard using PowerBI (Excel, Power Pivottools).
• Created SSAS Tabular semantic model with partitions, hierarchies and calculated measures using DAXas per business requirements
• Built Dashboards /Reports/ combine different datasets and publishing using PowerBI Desktop tools
• Worked on Visualization, Merge queries and enhancements using PowerBI desktop tools.
• Worked on deploying, sharing reports/Dashboards to Microsoft PowerBI service.

Environment: SQL, SQL Server Integration Services (SSIS), Sql Server Reporting Services (SSRS), SSAS (Tabular), Power BI, DAX

Confidential

MSBI Developer

Responsibilities:

• Involved in requirements gathering from the customer.
• Preparing the design document.
• Created target tables according to reporting requirements and created primary and foreign keys.
• Extracted data from various sources like .CSV, Excel and Text file from Client servers and through FTP.
• Developing SSIS package to process files and load them into target database.
• Used For-Each Loop Container, Sequence Container, Scripttask, Expressions, Execute SQLtask, Variables, Send MailTask,FTPTask,Package Executiontaskto achieve business needs.
• CreatedSSISpackages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Aggregate, Pivot Transformation, and Merge Join and Union all.
• Created configuration file to make configuration changes once it is deployed into production.
• Scheduled Jobs for executingSSISpackages which were developed to update the database on Daily basis using SQL Server Agent.
• Testing the SSIS Package by writing custom queries in stage and target database.
• DeploySSISPackage into Production and used Packageconfigurationto export various package properties to make package environment independent.
• Developing SSRS Reports based on the requirement.
• Generated SQL Server Drill down, Drill through, Cross tab report using SSRS to fit business requirements.
• Testing the reports based on the requirement.
• Publishing the report to SQL Report Server.
• Deployed the generated reports on to the Report server and fine-tuned the database objects to ensure efficient data retrieval.
• Worked on with Report Manager, Report Builder, Report Security and Reporting Services Configuration manager.
• Created subscriptions for the reports to run every Monday Morning containing the details of weekly sales for their location for assessing the business for that week.

Environment: SQL Server Integration Services, SQL SSMS, SSRS

Confidential, Long Beach, CA

MSBI Developer

Responsibilities:

• Designed and created SSIS packages to extract, transform and load data from Excel and Text to SQL Server destination using various complicated transformations like conditional split, derived column, and data conversion for fee schedules from the existing QNTX database.
• Modified the existing packages by making changes in the stored procedures according to the requirement.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Transferred data from various OLTP data sources such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2008R2.
• Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report services (SSRS).
• Used various data flow transformations like conditional split, look up, derived column etc.
• Worked with T-SQL to create tables, stored procedures and user defined functions for complex business logic.
• Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using T-SQL.
• Involved in performance tuning for new databases and existing databases by using SQL profiler.
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.
• Used Event handlers to run send mail tasks in the background upon success or failure of a package in SSIS.
• Collaborated with fellow team members through Team Foundation Server for effective project management which includes work issues and track on the update of versions.
• Involved in troubleshooting, enhancing and creating new ones of claims retro report templates.

Environment: MS SQL Server 2008R2, SQL Server Integration Services (SSIS), SSAS, SSRS, OLTP, Business Intelligence Development Studio, Visual Studio 2010, SQL Server Profiler, SQL Server Management Studio, Excel, TFS, Windows XP.

Confidential

BI Developer

Responsibilities:

• Involved in requirements gathering from the customer.
• Preparing the design document.
• Preparing SQL Server Scripts to fetch the required data from database.
• Designed Cubes with Star Schema using SQL Server Analysis Services (SSAS)
• Involved in Analyzing, designing, building & testing of OLAP cubes withSSASand in adding calculations using MDX.
• Testing the cube with respect to database.
• Creating SSIS Package to scheduling the Cube Process.
• Scheduled cube processing from staging database tables using SQL Server agent inSSAS.
• Building the Framework Manager Model and publishing to Cognos Environment.
• UsedFrameworkManager to create different layers like Database Layer, Transformation Layer and Presentation Layer by defining appropriate relationships between query subjects.
• Creating Analysis Studio Reports and Demo to Customer.

Environment: SSAS (Multidimensional Cube), Cognos8 BI, Framework Manager, SQL.

Confidential

BI Developer

Responsibilities:

• Developing Functional and Technical Specification documentation.
• Analysis of tables in Development DW.
• Create reports in Report Studio (chart, list, crosstab, pie, drill, conditional formatting)
• Implement User Access at report level
• Scheduling the reports and creating the views.
• Testing of reports across the requirements.
• Deployment of cubes, reports and packages in production environment.
• Testing of reports in production environment,
• Updating documentation for reports, Cubes and packages.
• Participated in migrating the project from Cognos 8.4 to Cognos 10.1 Environment.
• Testing all reports and Cubes in new environment.