SUMMARY

• 9+ years of experience in various projects pertaining, and sound knowledge inManagement Information Systems, Market research, Supply Chain Management, Finance, Capital Markets, Financial Risk Management, Banking, Private Equity, Compliances, Venture Capital and Sustainable Investing.
• Succeeded in various roles such as Business Analyst, Sr/Business System Analyst & ScrumMaster with proven abilities in Leadership to guide and motivate the teams in various business settings
• Adept in SDLC methodologies and Worked in WaterFall, SCRUM, KANBAN and SCRUM - WaterFall Hybrid
• Certified ScrumMasterwith effective management of self-organizing and cross functional teams
• Optimized Business Process by Identifying Key Performance Indicators (KPIs) to analyze the need of clients leading to value creation for the organization and customers.
• Certification inHadoop Implementation & Application Framework, Big Data, Transitioning from Data Warehousing to Big data, No SQL Database from University of California San Diego (Coursera.org)
• Understanding of Hadoopconceptsin MapReduce 1.0 & MapReduce 2.0and tools such as Spark, Hive, Falcon, Ambari, Pig, Flume, Sqoop, NFS, Kafka, Job Tracker, Task Tracker, Name Node, Data Nodes, YARN (Map R2.0), and H-base
• Experience working in Big Data Environment, majorly on Hortonworks Data Platform, CHD 3.0and its components
• Good knowledge in implementing Business logic and optimize the queries using Hive Language(HiveQL)
• Good understanding ofHadoop Distributed File Systemarchitecture and Map Reduce Version 2.0 Framework
• Possess experience in monitoring large volume of streaming data using Apache Flume and Apache Kafka
• Good knowledge in Data-warehouse and Experienced inER model, Dimension model (Conceptual and Logical), Star, Snowflake schema, Fact Tables, and Data Integrity with triggers and constants (GIGO)
• Experience in preparing adata warehouse requirement documents, iteration matrix and business matrix. Adept at writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary and interface requirements documents.
• Possess strong knowledge on concepts like data profiling, data mining, data migrating, data mapping, ETL process, data masking, top down and bottom up approach, OLTP, OLAP, MOLAP, ROLAP, HOLAP &DOLAP
• Possess extensive knowledge in different data ware house architectures like centralized architecture, dependentbus architecture, independent data marts, federatedarchitecture, hub and spoke architecture
• Experience in data transformation, data mapping from source to target database schemas and data cleansing procedures using Informatica Power Center and SSIS
• Strong knowledge in Statistical Modeling/Analytics such as Linear/Logistic Regression Models, Cluster Analysis, Predictive Models, K-Means Clusters, Text Analytics using R studio and Social Media Sentiment Analysis using IBM Watson and R studio
• Involved in Query Optimization and Performance Tuning using SQL Profiler, Index Tuning Wizard and stored procedure Debugger.
• Hands-on proficiency in SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits, Aggregate, Derived Column, Event Handlers, and Error Handlers etc. and extensively used SSIS to load Data Warehouses.
• Strong experiences to design, deploy, and maintain various SSRS reports in SQL Server.
• Excellent experience in designing and developing stylish and complex reports using Drill Down, Sub Reports, Cascading parameters, Drill-Through Reports, Parameterized Reports, Chart Reports and ad-hoc reports using Global variables, Expressions and Functions for Business Users using SQL Server Reporting Services (SSRS).
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS and in adding calculations using Multidimensional Expression (MDX).
• Strong knowledge on SOA, N-tier Architecture, XML parsers, SAX, DOM, XPath, SOAP & RESTful web services and Strong understanding on the concepts like AJAX, Single Page Application (SPA), JSON documentation, XML schema definition (XSD), Extensible Stylesheet Language Transformations (XSLT), Web Service Description Language (WSDL), Universal Description, Discovery and Integration (UDDI) and API’s such as IIS, Apache
• Fluency in API documentation (JSON documentation & XML documentation) using Swagger, IO docs for JSON &XNSDOC for XML
• Implemented business logic into Web services using scripting languages and documented Web Service Level agreement (WSLA), XML mapping and XML schema document for WSDL definition using SOAP protocol.
• Proficiency in conducting Risk analysis&Risk Mitigation, Gap Analysis, What If analysis, Root cause analysis, As-is model, To-be analysis, Change management, change control, SWOT analysis and Cost benefit analysis
• Effectively performed Business Impact Analysis and Technical Impact Analysis to implement change and handle change request management
• Strong skillset and Experience as a Scrum Masterin facilitating scrum process and to coach, motivate& remove the impediments of scrum team to create conducive environment for healthy self-management&cross functionality.
• Facilitated scrum ceremonies such as Sprint Planning, Daily Scrum, Sprint Review & Sprint Retrospective meetings along with Backlog Refinement/Grooming activity.
• Monitored and Performed periodic analysisof KPIsin scrum/Agile including (but not limited to) Velocity, Story Cycle Time, Estimation accuracy, Technical debt management, Actual stories vs committed stories Defects per story point, release cycle and Retrospective process improvement.
• Good understanding of Vertical and Horizontal slicing to breakdown epics into user stories to satisfy INVEST criteria.
• Well versed with Estimation techniques such as Zoo chart, Planning Poker, Dot voting, T-shirt sizing, Bucket sizing, Relative mass evaluation and affinity sizing.
• Managed Requirement churn effectively using prioritization techniques including (but not limited)Opportunity scoring, MoSCoW, Kano, Walking skeleton, Theme screening, Story mapping and value vs risk.
• Tracked team performance by recording and maintain artifacts such as Sprint burndown chart, burnup chart and Impediments list.
• Experienced with Object oriented analysis and design (OOAD) using UML (Use case, activity, data flow, process flow and sequential diagrams), Rational Rose and MS Visio
• Expertise in Graphic User Interface Design, wireframes and UI mock-ups using tools like Balsamiq
• Experience in eliciting Business Requirements with various techniques, Joint Application Development (JAD), Observation, Interviews, Document Analysis, Prototyping, Interface Analysis, Conducting Survey
• Excellent skills in creating artifacts such as Business Requirement Documentation (BRD), Functional Requirement Document (FRD), System specification document (SRS), Requirement traceability matrix, RACI chart and Risk registry
• Designed and executed test plans, scheduled test cycles, test data and test cases. Tracked defects and got them resolved to ensure that business requirements and functional specifications are tested and fulfilled.
• Experience supervising Blackbox Testing, Functionality Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT), Load/Stress Testing, and Performance Testing. Worked with QA team to design test plans and test cases for User Acceptance Testing (UAT) using HP Quality center
• Optimistic and Excellent skills in Business Intelligence Analysis and Raw data analysis, addressing the problem statement and solving the business problem through analysis of huge datasets using MS EXCEL, MS Power BI, IBM Watson Analytics, IBM Cognos, SSRS, Pentaho, Tableau and R studio.
• Certification from Columbia University(Coursera.org) in Financial Engineering& Risk Management.

TECHNICAL SKILLS

Project tools/ Methodologies: MS Project, MS SharePoint, AGILE SCRUM, SCRUMBAN, SAFe, KANBAN, WATERFALL, Extreme Programming and SPIRAL

Requirement Management: JIRA, RALLY, VERSION ONE, Blue Print, HP ALM 11.5, Confluence, TFS

Data Warehousing: Teradata, Data Modeling, Dimensional Data Modeling, Data Mining, Data Marts, Facts, Dimensions, Schemas, OLTP, OLAP, Slice/Dice, Roll-Up, Drill-Down

Databases: HBase, MySQL, MS Access, NoSQL, Oracle 10g/9i/8i/7.x, SQL Server 2008/2012, Sybase, DB2

Analytical Tools / Reporting Tools: QlikView, Crystal Reports, Micro Strategy, Pentaho, Tableau, MS EXCEL, MS Power BI, R Studio, IBM Watson Analytics, IBM Cognos, Informatica, Google Cloud Data lab, VBA, Macros

Programming/Scripting Languages: SQL, PL/SQL, T-SQL, R and Python

Modeling & Data Modelling: Prototype, Balsamiq, Erwin, Power designer, oracle Designer, ER / Studio, Rational Rose, MS Visio, Embarcadero

ETL Tools: Informatica 8.1/7.1.3/7.1.1/6. x/5.x and SSIS, IBM data stage, Pig, Hive, Sqoop, Flume, NFS

Testing Tools: Load Runner, Selenium, HPALM, HPQC, SOAP UI, BUGZILLA

Domain Skills: Banking, Insurance, Financial Data Analysis, Financial Risk & Compliance management, Sales & Trading, Swaps, Debt Capital Markets, Equity Capital Markets, GAAP, Securities, VaR analysis, Market Research, Supply Chain Management.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Business System Analyst/Project Manager

Responsibilities:

• Managed Project for complex system migrations involving the transition of programs and features to HNB platforms from acquired company.
• Providedproject administration for full software development life cycle, from conducting initial feasibility studies to delivering final user training
• Created Data retention document, Data transmission document and Decommission Status document
• Measure and trackprojecttask and progress through MSExcel
• Rapidly completed 10end to end decommissions ofprojectefforts which included business segment databases and applications
• Supported allprojectplanning & program coordinating activities &PMO Governance for EIM releases and deliveries
• Define and record EIM (Enterprise Information Management) requirements for Business Intelligence reporting applications, MicroStrategy and SAS
• Build EIM Requirements for the Enterprise Data Warehouse and associated tools and applications.
• Work across Business and IT delegates to document business requirements that are translatable to IT Design and Development
• Created Input mapping & Output mapping documents for EDW & MDM
• Build Data Mapping documents that detail field level correlations for design and development of ETL.
• Work with Business and Technical resources on any changes or clarifications that occur during the project lifecycle.
• Work the designated QA resources on any requirements clarification or test plan traceability to requirement documentation.
• ImprovisedHNB Enterprise Information Management policies and guidelines on Data Mapping and Data Quality.
• Adheres to bank policies and procedures and comply with legal and regulatory requirements
• Follow, or in some cases establish, as required, effective controls and processes to ensure risks are measured, monitored and controlled and compliance requirements are adhered to on an on-going basis.
• Remain current on risk-related changes that may impact assigned work functions and processes
• Report status and progress to assigned Manager and IT service deliver director on regular basis.

Environment: Waterfall, Microsoft Excel, MicroStartegy, SAS Warehouse, SQL Server, Network Access Storage, ServiceNow, Outlook, IBM Data Studio 4.1.2 Client

Confidential, Columbus, OH

Scrum Master/ Sr. Business system analyst

Responsibilities:

• Served as liaison between business owner, Hadoop coordinators, Hadoop developer, Data Analyst, Data governance, and Data operations to execute data requests within risk and controls matrix
• Partnered with the business line to Elicit Business Requirements by conducting JAD sessions, Focused group, Interviews, conducting surveys/questionnaires, Document Analysis, alongwith project stakeholders and business owners
• Point of contact for user support and problem-solving.
• Prepared documents on compliances risk reports relating to (but not limited to)BASEL (I, II, III), SOLVENCY, BCBS #239, FFIEC, FDIC, SEC, DODD FRANKto give brief overview of regulations & regulatory boards.
• Analyzed the data sources and categorized them into Business Requirements and further translated them into Functional Requirement Document (FRD) and System Requirement Specification (SRS)
• AnalyzedBusiness Requirement Document (BRD), and convert those requirements into epics and user stories with the help of the Scrum Development Team and Product Owner.
• Collaborate with stakeholders to ensure information and approvals are accurate and documented in alignment with Firm-wide Data Management Standards for new data sources.
• As a Scrum Master, facilitated and time-boxed the Scrum ceremonies (Sprint Planning Meeting, Daily Standups, Sprint Review Meeting, Sprint Retrospective Meeting and Grooming Sessions)
• Created and maintained Sprint Burndown Chart, Sprint Burn-up Chart, Product Release Chart, White Board to keep track of the team’s progress and the team’s velocity for better estimation of the sprints.
• Worked extensively on creating UML Diagrams, Use CaseDiagrams, Activity Diagrams to visually describe the financial modelling/simulation/risk analyticsalgorithm usingMS Visio
• Generate KPI reports on data project and identify enhancement opportunities across products by creating Dashboards, Visualization and Reports using MS EXCEL and TABLEAU
• Fetched data from UNIX file system on to the nodes of Hadoop Distributed file system (HDFS)
• Coordinated with the Hadoop administrator to commission and decommission the nodes in HDFS as per the requirements using the tools like Ganglia, Nagios and Cloudera Manager Enterprise
• Involved in extracting feeds from News channels, Social Media, Capital market data store and third party data(i.e. Satellite Imagery) providers using Sqoop
• Coordinated with the Hadoop developer to improve the performance of the Pig library by writing user defined functions (UDF’s) in python scripts and JSON scripts
• Implemented partitioning and bucketing techniques in HIVE to improve the performance
• Triggered the data workflows based on time or availability of XML data, and performed data ingestion and merging of the XML data using the Apache Oozie Coordinator Engine which also automates the recurring Hadoop job
• Guided the team to perform the loading ofbatch queries to In Memory Data grid (IMDG) and real time queriesto Data Platform, to have accurate analysis real-time data by comparing it to the vast amount of data in Hadoop Cluster.
• Analyzed the queued-up time series data and generated risk events such as Credit risk, Market risk and Compliance risk using Apache Storm system
• Correlated the generated business events with other third party data such as Satellite Imagery, Financial Reports, Market Analysis Reports with the help of Apache Kafka
• Responsible to transfer the data from Hadoop system to analytical data store and vice-versa using Sqoop module
• Managed and reviewed Event log files, Hadoop output log files and job status with the help of Avro and HTTP Data Sinks
• Collaborated withstakeholders and technical staff to investigate, analyze, and resolve application problems related to system functions.
• Frequently interfaces with business lines, including management, and/or internal resources to ensure quality, timeliness, and testing of all release work.
• Reviewed, coordinated, and executedTest plans and ensures that Test cases and Test results meet requirements.

Environment: Scrum, Hadoop Cloudera (CDH) distribution 5.0, Linux, Hue, Oozie, Sqoop, Hive, HDFS, HBase, Scala, Flume, Spark, Maven, Junit, Jenkins, Python, GIT, Kafka, Solr, Mockito, HBasetestingutility, Zookeeper, MS Visio, JIRA, Tableau 9.1, Balsamiq, Blue print.

Confidential, Owings Mill, MD

Scrum Master/ Business System Analyst

Responsibilities:

• Performed Gap Analysis to identify the deficiencies of the current system and to identify the requirements for the change in the proposed system.
• Facilitated JAD sessions, Interview sessions, Survey/Questionnaire and Focus Groups to Elicit Requirements
• Facilitated various Scrum ceremonies such as Backlog Grooming Meeting, Daily Standup Meeting, Sprint Planning Meeting, Sprint Review Meeting and Sprint Retrospective Meeting
• Implemented SWOT analysis to short list and fine-tune requirements for the product backlog.
• Assisted Product Owner in identifying right prioritization techniques for prioritizing the backlog.
• Documented and tracked user stories in Rally.
• Helped Product owner understand the technical user stories as the user stories are spilt to get into sprint
• Prioritized user stories using MoSCoW and Kano Analysis along with Scrum team and product owner.
• Facilitated the estimation of efforts required using Planning poker along with Scrum team.
• Used JIRA to keep track of the issues that are logged and in progress along with the person responsible. It helps to generate reports to see the current status of the issues.
• Empowered team to self-organize and grow cross-functionally.
• Protected team from over commitment, managed backlog, prioritized the resolution of defects/bugs as evidenced by the on-time delivery.
• Facilitated the team to maintain optimal velocity and work on completing story points with a consistent schedule in each sprint.
• Helped the team overcome a technical barrier by creating and updating use case diagrams, Activity diagrams, Sequence diagrams using MS Visio
• Developed Wire Frame diagram for GUI that helps developers to prepare real time easily accessible screen layout
• Coordinated with the Hadoop administrator in monitoring, provisioning and managing ofHadoop cluster
• Monitored the Hadoop log files and File Management system using JMS Data sinks where these logs data were consumed usingApache Flume
• Wrote X-Query (XML Query) to transform the collected structured and unstructured data to binary from
• Documented the XML’s into PDF using XSL-FO (XSL Formatting Objects) for the management to access the documents
• Coordinated with the Data Analyst in creating the HIVE tables as per the requirements
• Involved in importing the data from MySQL to HDFS on regular basis using Sqoop
• Performed Data Quality Analysis procedures, manual matching techniques to rectify data inaccuracies
• Coordinated with the QA team in designing test plans and test cases for User Acceptance Testing, and validated the test cases using requirement traceability matrix(RTM).

Environment: Scrum, Rally, JIRA, HP Quality Center 10.0, MS Visio, HDFS, Oozie, Apache Flume, Apache Kafka, Apache Storm, Map reduce 2.0, MS Project, MS Office, Mock-up Screens, Load Runner, Bugzilla, SAP Business Objects BI, Confluence.

Confidential, Philadelphia, PA

Scrum Master/Business system Analyst

Responsibilities:

• Developed good understanding of Financial Instruments, Asset Allocation, Bonds, Corporate Bonds, Money market instrument, Fixed Income, Credit and Market Risk.
• Analyzed prior documents and Gathered Business Requirements, analyze data/workflows.
• Defined the scope, financial projections and Cost/benefit analysis. Progressed from Problem Statement to well-documented designs.
• Conducted JAD sessions, Document Analysis and Interviews with Stakeholders for requirement elicitation.
• Prepared Business Requirement Documents (BRD) and Functional Requirement Document (FRD).
• Decomposed BRD into User Stories by conducting story writing session with product owner
• Facilitated scrum ceremonies such asSprint Planning, Daily Scrum, Sprint Review and Sprint Retrospective.
• Helped to prioritize user stories using MoSCoWand Relative mass evaluationtechniques.
• Created User stories, Use Cases, Use case diagrams, Workflow Diagrams, Sequence Diagrams, and Class Diagrams etc.
• Involved in Test Planning, Test Preparation, Test Execution and Issue Resolution and Report Generation to assure that allaspects of a Project are in Compliance with the Business Requirements.
• Defined Acceptance Criteria for User Stories to perform User Acceptance Testing. Designed Test Cases, Test Plans, Test Scripts, and Test Scenarios to perform Functional Testing, and Regression Testing and logged down defects using JIRA.
• Designed data models and conducted normalization and de-normalization of data to fit OLTP and OLAPframeworks, slicing and dicing of data marts for analytical decision making support.
• PerformedExtraction, Transformation and Loading (ETL) using Informatica.
• Worked on service oriented architecture (SOA), REST, SOAP, XML, API.
• Logged and tracked the defects using HP ALM and created an error repository and managed the testing process with the QA team.
• Assisted in the creation of deployment flow chart in conjunction with development, infrastructure, and network teams containing information for maintaining Application.
• Planned and organized team engagement activities to encourage self-organization among the team.
• Proven record of Team Management and Leadership skills.

Environment: Scrum - waterfall Hybrid, MS project, MS office Tools, MS Visio, AJAX, JAVA EE 6, MySQL, Zend framework, PHP 5, jQuery, Memcache,Oracle 11g,Spotfire and JIRA, Informatica v9x, Eclipse, Hibernate Spring.

Confidential

SR. Business Analyst/Business System Analyst

Responsibilities:

• Understood state of art processes by interacting with stakeholders and documents analysis.
• ConductedGAP analysisfor AS-IS model & TO-BE modelto assist Project Manager in planningand to identify all requirements
• Facilitated JAD sessions as Moderator and conducted interviews with various Subject Matter Experts (SMEs) and stakeholders, process reviews and policy& procedure reviews to elicit requirements.
• Reviewed and updated existing workflows, IT systems, user profiles and permissions, reporting needs & all end to end process related to function of registries in Business Analysis Documents.
• Prepared Business Requirement Document (BRD/HLD) and assisted preparation of System
• Created System Requirement Specification (SRS). Analyzed, modified and validated these documents.
• Created Use Cases andbuilt Use Case Diagram and Activity Diagram using MS Visio.
• Assisted Data modeling process by creating conceptual and logical ER diagrams and designing database schemas to help development of an accurate Data Warehouse Structure.
• Integrated various OLTP to the OLAP using Informatica for ETL operationand have maintained the Bill Inmon’sand Ralph Kimball’s Paradigms.
• Helped in implementing Enterprise Data Governance model and actively promote the concept of data sharing, data reuse, data quality and data standards.
• Assisted in increasing Data Integrity by performing Data Normalization and adding Data Verification and Validity to maintain accuracy and effectiveness of data
• Performed Data Mining to find correlation and pattern in existing data and constructed complex SQL queries.
• BI reporting usingTableauand MS Excelto facilitate expenditure tracking using various matrices critical to decision making.
• Involved in implementation by assisting in the preparation of training module.
• Helped the end users getting accustomed to the system by live demonstrations and system tutorials.
• Timely tracked progress and reported it to Business Owner and Project Manager.
• Managed and tracked requirements using HP ALM through Application Life-Cycle.
• Worked with QA team to design and develop Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional Testing and Regression Testing.

Environment: Waterfall, MS Office (MS Word, MS Excel, MS PowerPoint), Tableau, Informatica, MS Visio, MS Project, HP ALM, Wireframes, Mock-Up Screens, MS SQL Server 2008, SSIS, SSAS, SharePoint,SSAS.

Confidential

Business Analyst/Business Data Analyst

Responsibilities:

• Tracked project status and participated in meeting with clients to give project status update and gather details on changes.
• Conducted GAP analysis, AS-IS & TO-BE models to analyze the variance between the system capabilities and business requirements.
• Business/Functional Requirement gathering for all interfaces such as Business Requirement Document (BRD), FSD (Functional Specification Document) and Functional requirement documents (FRD)
• Document various Data Quality mapping document.
• Co-worked in Creating Source to Target Data Mapping sheets to provide detailed explanation of ETL requirements.
• Creating source and target table definitions using SSIS. Source data was extracted fromFlat files, SQL Server and DB2 Databases
• Utilized Informatica toolset (Informatica Data Explorer, and Informatica Data Quality) to analyze legacy data for data profiling
• Responsible in maintaining the Enterprise Metadata Library with any changes or updates
• Extracted data from Teradata using SQL Pass through facility and generated ad-hoc reports.
• Write T-SQL statements for retrieval of data and also involved in performance tuning of TSQL queries
• Perform small enhancements (data cleansing/data quality).
• Worked on daily basis with the main frame team and lead data warehouse developers to evaluate impact on current implementation.
• Coordinated (with business users, data base administrator, mainframe team and testing team) in mirror to production testing.
• Conducted User Acceptance testing (UAT) and worked with users and vendor who build the system

Environment: Waterfall, T-SQL, Informatica, DB2, MS SQL Server, SSIS, SSAS, SSRS, HP Quality Centre, Rational Rose, Mock-up screens, Wireframes.

Confidential

SQL Developer

Responsibilities:

• Conducted Performance tuning/MS SQL server development - SQL scripts, stored procedures, triggers, functions and transactions analysis, thorough understanding of indices andstatistics (Query Optimizer).
• Conducted logical and physical database design including data modeling, maintenance, problem diagnosis and resolution.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzerand SQL Enterprise Manager.
• Created and administered multiple development, training and production databases.
• Developed and created data dictionary, advanced queries, views, indices, and functions for databases.
• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning and SQL Server clustering, managed database quality assurance including database consistency check.
• Responsible for creating standards and operating procedures to maintain all databases.
• Worked with development teams in the design of physical databases and in modification.
• Reduced systems downtime risk through automatic offsite backup and recovery over network.
• Responsible for database security of the operational and developmental application system databases.
• Managed MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks.

Environment: MS SQL Server 2000/2005, T-SQL, Oracle 8i/9i, TOAD, Micro strategy, Microsoft Visual Source Safe, MS Visio 2007, MS Projects 2007(v12.0).

Confidential

SQL Developer/Jr. Analyst

Responsibilities:

• Involved in all phases of SDLC, and gathered business requirements from business people.
• Design/develop database using SQL SERVER 2005/2008.
• Created SSIS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files and Oracle databases.
• Designed and Developed Complex SSIS packages for auditing Interfaces using SQL SERVER 2005 Integration Services.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Developed custom Reports, Ad-hoc reports by using SQL Server Reporting Services (SSRS).
• Developed Tabular, Drill Down, Parameterized, Cascaded and sub-reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions based on the requirements using SSRS 2005.
• Created Parameterized Reports and Linked reports and thorough knowledge of report serving architecture using SSRS.
• Deployed SSRS Reports in SharePoint Environment.
• Creating complex T-SQL Stored Procedures, Functions, Triggers, Cursors, Tables, and Views and other SQL joins and statements for applications.

Environment: MS SQL Server Management Studio 2005/2008, Query Analyzer, SQL Profiler, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), SharePoint Workspace, Windows XP.