SUMMARY

• Around 6 years of experience working as a Business Analyst/ Database with MS SQL technology. creating BRDs (Business Requirement Documents), FRDs (Functional Requirement Documents), process flow diagrams, Use Cases, User Stories and other artifacts in the Healthcare, Financial, and Insurance sectors using IT Business Analytics and modeling, during all phases of SDLC (Software Development Life Cycle)
• Worked closely with Business to define and document business needs, requirements, processes, and data needs, using various requirements gathering techniques including but not limited to, requirement gathering walkthrough session, one on one interviews, JAD sessions, brainstorming, and wire framing
• Proficiency working in the Waterfall and Agile methodologies
• Efficiently coordinate with other team members for defect/issues resolutions, during the complete STLC (Software Testing Life Cycle) during SIT (Systems Integration and UAT (User Acceptance Testing) during Release Phase
• Facilitated and managed sessions with Project Sponsors, Business owners, Product Mangers, SMEs and Analysts from various business areas.
• Provide documentation and basic training to the business team on how to use SQL Developer and create basic SQL queries for research and analysis against the new data mart.
• Prepare and present formal reports to management to assist in effective Decision making.
• Hands - on experience with Project coordinating activities like: Working closely with Business /Stakeholders for documenting Scope Document, Project charter, etc.; Working with IT teams for gathering estimates, leading project status meetings, handling and communicating change control work, conducting cost-benefit analysis, resource management tasks, etc
• Used SQL developed queries and extracted raw data.
• Knowledge of Agile (Scrum) methodology, to manage project components from inception, elaboration, construction and transition phases of SDLC for lending team, through User Stories in Product/Sprint backlogs thru the pre-determined iterations
• Good understanding in implementing different types of Replication Models such as Transactional, Snapshot, Merge and Peer to Peer.
• Reproduced Tables and Views containing Firewall Policy data by transferring Big Data with historical and current data to SQL Server, using SSIS
• Expert in automating the system by using Notification service and creating alerts, jobs and Maintenance plans.
• Developed system to feed widgets to web based Productivity Tracking System (PTS) with data from various sources using SQL 2000.
• Used SiteMinder to create a query scheme which defines the SQL queries to authenticate users against the DB, get attribute information, etc.
• Ample of experience in data warehousing using star schema and snow flex schema.
• Ample of knowledge in Relational Database Management Systems (RDBMS) & Entity Relationship Diagram (ERD).
• Data analysis (hands on SQL/PL SQL; EXCEL)
• Knowledge of SQL, experienced in data mapping, data modeling, data analysis, design of ETL process, data warehousing concepts and Business Intelligence solutions;
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Able to work independently and collaborate proactively & cross functionally within a team.

TECHNICAL SKILLS

Databases Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), Database Engine Tuning Advisor(DTA), Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, Jobs and task creating and scheduling, MS Visio, Crystal Reports 10.0, SQL reporting, SSIS

Programming Languages: SQL, TSQL, XML, PL/SQL, C, C++, VB 6.0, Perl, HTML, XML.

Web Tools: ASP.NET, ASP.NET MVC, ASP, JavaScript, ExtJs, MS-Front Page, Internet Information Server(IIS),FTP,TCP/IP,LAN,MS-Outlook Express

Operating Systems: Windows 95/98/2000/2003/2008 R2/2012/XP/NT 4.0, Linux, Novell Netware, MS-DOS.

Utility Tools: MS Office, MS Project, Clear Quest, Visual Source Safe 6.0, Rational Clear Case.

ETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data, Bulk Copy Program (BCP)

PROFESSIONAL EXPERIENCE

Confidential, Milwaukee, WI

Business Analyst

Responsibilities:

• Provided expertise in the business units we support.
• Additionally, I worked with business partners operations to understand their strengths and weaknesses to determine opportunities to automate processes and functions
• Assisted in; the business process redesign and documentation as needed for new technology
• Translated high level business requirements into functional specifications for the IT organization
• Participated in agreement negotiations by facilitating communication between business units and IT from initial requirements to final implementation utilizing expertise in technological trends
• Conduct meetings, interviews and JAD sessions with stakeholders to understand and collect requirements.
• Documented the requirements and upload them to Team Room for tracking and cross verification.
• Worked as a liaison between business and IT teams to convey expectations and provide clarifications on what is needed and what can be achieved from the technology perspective.
• Worked with testers to clarify requirements during disagreements between QA leads and developers on expected end results.
• Developed SQL codes and created stored procedures based on business needs.
• Worked with end users and application team to develop queries based on business needs.
• Created central database to store details of all instances.
• Monitored databases/instances for uninterrupted business support.
• Experiencein trouble shooting and fine-tuning of databasesfor itsperformance and concurrency.
• Provided documentation for the implemented procedures which involves Go Live activities and support work.
• Developed system to feed widgets to web based Productivity Tracking System (PTS) with data from various sources using SQL 2000.
• Using Oracle SQL developed queries and extracted raw data on network system maintained on Oracle database server.
• Provide documentation and basic training to the business team on how to use SQL Developer and create basic SQL queries for research and analysis against the new data mart.

Environment: MS Word, MS Excel, JReports, MS Project, MS Visio, Oracle, MS UML, MS SQL Server Enterprise Edition, BIDS, SSIS, SSRS, SQL Profiler, Database engine tuning Advisor, T- SQL

Confidential, Detroit, MI

Business Systems Analyst

Responsibilities:

• Acted as a liaison between the developers and management staff and was instrumental in resolving conflicts between the management and technical teams.
• Gathered and reviewed business requirements from multiple sources (SME's, Department Managers, Business Leads) to capture base requirements and customization needs and to create BRD's utilizing MS Word, Excel, PowerPoint and Visio.
• Worked with the end-users to gather information and create business requirement documents (BRD) and functional requirement documents (FRD) that were then discussed with and explained to the onshore and offshore development teams
• Lead review of requirements with Business for verification and pre-sign-off
• Conducted Joint Application Development (JAD) sessions as well as individual sessions
• Strategized with Business Leads and Project Managers to create project timeline
• Documented requirements and project related items in SharePoint
• Collaborated on weekly Validation Session
• Populated Excel Pivot Tables on the Front End, used to generate the final reports, by implementing Queries, Stored Procedures, Triggers, Views, Indexes on SQL Server
• Developed complex SQL scripts to enable direct download of data maintained in enterprise database for data extraction directly into reports
• Created and collaborated on Training documentation and User Guide material
• System testing - provided additional support for Test Case generation and processed Test Cases and provided feedback to development team as needed
• Facilitated User Acceptance Testing
• Developed SQL Server Reporting Services (SSRS) reports as needed to communicate and support database maintenance and support tasks.

Environment: MS Word, MS Excel, MS Project, MS Visio, Oracle, MS UML, MS SQL Server, Business Intelligence Development Studio(BIDS) - SQLServerIntegrated Services (SSIS), SQL Server Reporting Services (SSRS), JavaScript, SQL Profiler, Database engine tuning Advisor, T- SQL

Confidential, Oakbrook, IL

Business Analyst

Responsibilities:

• Created Business Requirements Document (BRD) providing an outline explaining the Customer/Business requirements, Process Model (Current/Target Environment), Business Use Cases for new users’ password creation and existing users’ password reset process
• Generated the detailed reports of the Bugs, Pass-Fail report and Assigned defects.
• Reproduced Tables and Views containing Firewall Policy data by transferring Big Data with historical and current data to SQL Server, using SSIS.
• Created test scenarios for User Acceptance Testing (UAT) on the new procedures.
• Participated in walkthrough and defect report meetings periodically.
• Supervised a team of 5 Help-Desk analysts who assisted end-users with their day-to-day computer related issues, created, resolved and closed Remedy tickets or escalated them to the appropriate support groups
• Data analysis (hands on SQL/PL SQL; EXCEL)
• Oversaw development of databases for service desk and desktop support groups with-in BMC Remedy call tracking and ticketing system
• Provided regular status updates to senior management by updating RAID (Risks, Actions, Issues, and Decisions) log for the projects
• TSQL and VBA scripts were used to create an interface between the SQL Server and Excel
• Created ODBC connections for direct data download from SQL Server to Excel
• Worked directly with IT department heads, analysts and end users to gather information on the existing ticket flow and other IT processes, and created process flow documentation in MS-Visio for the review of IT manager and department heads

Environment: MS Project, MS Visio, Oracle, MS UML, UAT, Tearadata database, MS SQL Server 2005, BTEQ, Fastload, Multiload, Analysis Services, Aster.

Confidential, Charlotte, NC

Jr. SQL Developer

Responsibilities:

• Configured and Installed SQL Server 2005.
• Developed, modified and optimized complex stored procedures, triggers and user defined functions.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Configured Transactional replication between Primary Server and three Read - Only servers, with separate Distributor server and experience in troubleshooting replication problems.
• Resolved the SQL Server 2005 upgrade hurdles and successfully Migrated SQL 2000 DTS packages to SSIS using Upgrade advisor and Package Migration wizard.
• For complex packages like password protected packages, packages created using SQL Native client used DTS Xchange tool.
• Additionally, designed and implemented a disaster recovery system.
• Very knowledgeable on SSIS, SSRS, Business Intelligence reporting applications.
• Upgraded SQL Server 2000 DTS Packages to SSIS for uploading various formats of files and databases to MS SQL Server 2005 using SQL Server Integration Services (SSIS).
• Migrated data from various data sources using SSIS Transformations like Aggregate, Lookup, Conditional-split, Merge Join, Web Service task and Sort.
• Generated reports in various formats like Table format and Matrix format using Reporting services (SSRS).
• Designed and deployed SSRS reports with drill down, drill through and drop down menu options and parameterized and linked reports.
• Scheduled and deployed reports using SSRS to generate weekly, monthly and quarterly reports including current status if required by the client or the management meeting strict deadlines
• Designed Solid detail design documentation for various SSIS conversion process.
• Configured Logging, Auditing, Sending mail alerts and check point files on production servers using SSIS.
• Using Team foundation server (TFS) to keep track of SSIS packages and SSRS reports.
• Using SSIS developed Interfaces for extracting and loading data from various sources like Intersystem cache database, SQL Server 2005 and CSV files.
• Using SSIS Implemented Incremental upload method on the tables for loading data based on new/existing records
• Developed SSIS Interface to read and load the Health Level (HL7) file into data warehouse
• Used various SSIS tasks & transformations like Pivot, Unpivot, conditional split, XML task, Script task, FTP and Send mail task
• Extracted large volumes of data from different data sources and loaded the data into target data by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Installing report server configurations.

Environment: SQL Server 2000/2005, T-SQL, Data Transformation Services (DTS), Reporting Services (SSRS), Integration Services (SSIS), Windows OS.