SUMMARY:

• Successful Project Management with Business Systems Analysis experience and progressive levels of responsibility with different skill set involved and large project size management with team mates both on site and off - shore.
• Capable leading projects from requirements through stabilization, following Software Development Lifecycle (SDLC).
• Huge experience using Team Foundation Server (TFS) for project related interaction
• Also versed with scrum meetings and arrangements to get periodic updates on different projects and their difficulties to seek solutions to move forward
• Lead teams on software development and best practices for developing BI applications.
• Highly motivated, self-starter that is also passionate about technology. Assesses and addresses a client's business needs and use right tools and frameworks to build effective solutions.
• Proven ability to act as liaison between business partners and IT
• Experienced to Communicate with both Technical and non-Technical audiences and to all level of management.
• Talents related to problem solving, and analysis of efficient and cost-effective efforts.
• Microsoft Business Intelligence Developer with experience in developing Business Intelligence applications, Data Warehouse applications at various phases of SDLC.
• Experienced in Testing of software’s, SSRS Reports and SSIS Packages before they go to Testing(QA and UAT) and eventually production
• Wide experience with SharePoint as a medium of communication amongst team members or client and for deployment of Reports
• Extensive experience on developing Business Intelligence applications with SSIS  and SSRS and wide knowledge of EXCEL to cleanse data from different sources, using proper naming conversion and saving files in created Shared Location before using SSIS to load into the database
• Good knowledge in other tools like UNIX(AIX) and VMware

PROFESSIONAL EXPERINCE:

Confidential, Atlanta, Georgia

Technology Analyst 

Responsibilities:

• Develop Design Documents from Requirement document and place them into TFS for review by team mates and vice versa.
• Build SSIS packages to load and mapped tables from source to destination databases.
• Design the Data Warehouse from scratch with respective Data Marts with Fact and Dimension Tables
• Deploy packages from Development Environment into QA and UAT Environments
• Extensive experience working in a SharePoint Environment to communicate reports to end users or client for decision making
• Worked on agile sprint based development process and successfully delivered various reports. 

Confidential, Milwaukee, WI

Technology Lead 

Responsibilities:

• Lead the MSBI Team to build packages using Integration Services (SSIS) for extracting data from Flat Files, Excel files, OLEDB to SQL  Server and other Databases. 
• Experience in Testing and does System, Unit and Integration Testing
• Responsible for loading the data using SSIS  packages to fact and dimensional tables. 
• Organize teams in different environments like Development, Test, and Production and Deployment
• Have developed and maintained T-SQL Stored Procedures, User Defined Functions and Data Models according to the business requirements.
• Manage team to developed database triggers to enforce data integrity, dependent tasks and for auditing purpose. 
• Build IT team to developed complex Stored Procedures and views to generate various Drill-down/Drill-through reports. 
• Extensive experience working in a SharePoint Environment to communicate completed projects/reports to end users or client for decision making

Confidential, Dallas, TX

ETL Developer and Project Manager

Responsibilities:

• Create plan that fits scope; define and clearly articulate project goals and milestones (stretch, yet realistic) assemble; coach, manage and motivate team. Also intervene to resolve technical and Business issues using problem solving skills that are second none. Example Brought stalled projects on track within two weeks by setting/ communicating clear vision, goals and milestones
• Head team responsible for efficient data insertion, manipulation and retrieval using various joins, indexed views, stored procedures and functions. 
• Manage MSBI Team to developed   SSIS  packages using for each loop in control flow to process all flat files within folder, File System Task to move file into archive after processing and execute   SQL  task to insert transaction log data into the   SQL  table. 
• Manage IT Team responsible for creating database objects like table, views, stored procedures, triggers, functions using T- SQL  to provide structure to store data and to maintain database efficiently.
• Extensive experience working in a SharePoint Environment to communicate reports to end users or client for decision making
• Worked on agile sprint based development process and successfully delivered various reports. 
• I Supported different teams through the entire Business Intelligence project life cycle Developed parameterized reports using SQL Server Reporting Services SSRS.

Confidential

IT Project Manager & SQL Server 

Responsibilities:

• Supported daily operations, resolve issues be engaging appropriate IT Teams and led projects for the Business Unit
• Build and manage SSRS Reporting team responsible for Designing and developing reports, sub reports, drill down reports and drill through reports using various features like Charts, graphs, filters etc. 
• Build and manage team Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler.
• Developed and created new database objects including tables, views, indexes, triggers, stored procedures and functions.
• I managed the codding team responsible for Writing and executing complex T-SQL queries using SQL Management Studio for back end data validation testing.